3 ms·
You can do basically anything I/O within an Excel macro (VBA script): You can talk to a database: https://stackoverflow.com/questions/18313899/vba-new-database
by zbentley 9y ago
You can do basically anything I/O within an Excel macro (VBA script):
You can talk to a database: https://stackoverflow.com/questions/18313899/vba-new-database-connection https://stackoverflow.com/questions/18313899/vba-new-databas...
Interact with the filesystem: https://stackoverflow.com/questions/11528694/read-parse-text-file-line-by-line-in-vba https://stackoverflow.com/questions/11528694/read-parse-text...
Open arbitrary sockets, with some caveats: https://stackoverflow.com/questions/125921/mswinsock-winsock-event-handling-in-visualbasic https://stackoverflow.com/questions/125921/mswinsock-winsock...
And more!