' execShell() function by Robert Knight via StackOverflow Next we will copy/paste the VBA code from the stackoverflow listed above (with minor changes):.Click “Create” and you will find yourself in the VBA editor with an empty Sub called getHTTP.In this case getHTTP.Īt this stage your Excel should look like this: In the “Macro Name:” field type the name of the new Macro we want to create.From the menu navigate to Tools->Macro->Macros….Save as “Excel Macro-Enabled Workbook (.xlsm)” file.Open an Excel file or create a new one.Given the above entry, let’s do a similar implementation here. To be clear our getHTTP will work on Mac but not on Windows, nor iOS, nor when opening the excel workbook from within the Web Browser.Īfter short googling I found multiple resources including this lovely entry called How do I issue an HTTP GET from Excel VBA for Mac 2011. Today’s goal is to build a user defined function that can be called from the Excel datasheet on Mac and fetch a web page. One particular item is the ability to fetch data from the Web.Īfter many years using Office and Excel I found myself learning to crawl (punt intended) again. I made the switch to Mac and now some of my old Excel macros that are depended on the operating system do not work. Discover how-to call a REST API endpoint from an Excel macro (VBA) on a Mac.
