4 ms·
Healthcare and insurance too! I transform into some glorious magical elf when I volunteer to do the VBA tasks nobody else understands or can lower themselves to
by schmookeeg 3y ago
Healthcare and insurance too! I transform into some glorious magical elf when I volunteer to do the VBA tasks nobody else understands or can lower themselves to do.
You can make Excel do some real wacky stuff. I have a spreadsheet that actually calls out to exec() to run a curl POST on commandline and consume REST API endpoints, parse the results, and update the spreadsheet -- why on earth?? because the API was ready but the web app was delayed. I was the fix. :D
- eli 3y agoPretty sure you can access a REST API from VBA without resorting to exec()
- Shorel 3y agoIt only works with toy examples and then stops working. For reasons unknown, as it should work.
- pillefitz 3y agoNever had issues with the standard VBA HTTP Interfaces
- schmookeeg 3y agoWe support both mac and pc excel -- the mac VBA is seriously gimped.