In cell A3 which will build the query string, enter: ='q=' & A1 Here's a specific example using a weather forecast web service ( )Ĭell A1 will be reserved for the name of the city.
If you don't have a module, click Insert->Module. To use this, copy the code above, open the VBA editor in Excel for Mac 2011. Read = fread(chunk, 1, Len(chunk) - 1, file)įunction HTTPGet(sUrl As String, sQuery As String) As String Private Declare Function feof Lib 'libc.dylib' (ByVal file As Long) As Longįunction execShell(command As String, Optional ByRef exitCode As Long) As String Private Declare Function fread Lib 'libc.dylib' (ByVal outStr As String, ByVal size As Long, ByVal items As Long, ByVal stream As Long) As Long Private Declare Function pclose Lib 'libc.dylib' (ByVal file As Long) As Long Private Declare Function popen Lib 'libc.dylib' (ByVal command As String, ByVal mode As String) As Long ' execShell() function courtesy of Robert Knight via StackOverflow I've tested this on a Mac running Mac OS X 10.8.3 (Mountain Lion) with Excel for Mac 2011. Doing further research, I came across Robert Knight's comment on this question VBA Shell function in Office 2011 for Mac and built an HTTPGet function using his execShell function to call curl.
