Pretty sure you can access a REST API from VBA without resorting to exec()
It only works with toy examples and then stops working. For reasons unknown, as it should work.
Never had issues with the standard VBA HTTP Interfaces
Re:Ask HN: Why did Visual Basic die?
by schmookeeg on Monday September 11, 2023 @07:38PM
(#37475140)
We support both mac and pc excel -- the mac VBA is seriously gimped.
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