How Do I Add Get Data From Web To My 2011 Excel Mac OS X 10

Ive tested this on a Mac running Mac OS X 10.8.3 (Mountain Lion) with Excel for Mac 2011.

Private Declare Function popen Lib libc.dylib (ByVal command As String, ByVal mode As String) As Long.

Private Declare Function pclose Lib libc.dylib (ByVal file As Long) As Long.

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.

Function execShell(command As String, Optional ByRef exitCode As Long) As String.

Change the value in A1 from London to Moscow -- A4 will change to the JSON-formatted forecast for Moscow.

Private Declare PtrSafe Function popen Lib libc.dylib (ByVal command As String, ByVal mode As String) As LongPtr.

Private Declare PtrSafe Function pclose Lib libc.dylib (ByVal file As LongPtr) As Long.

Private Declare PtrSafe Function fread Lib libc.dylib (ByVal outStr As String, ByVal size As LongPtr, ByVal items As LongPtr, ByVal stream As LongPtr) As Long.

Private Declare PtrSafe Function feof Lib libc.dylib (ByVal file As LongPtr) As LongPtr.

How Do I Add Get Data From Web To My 2011 Excel For Mac