I've had no problem creating web queries via VBA using Mac Excel 2004, if the HTTP method is GET. However, when I try to retrieve information using POST it appears that the request is still using GET (as observed in an HTTP proxy.)
Has anyone else been able to get HTTP POST requests to work using VBA on the Mac with 2004? (I am running the most recent update.)
Any/all help would be appreciated.
The code I am using is:
Has anyone else been able to get HTTP POST requests to work using VBA on the Mac with 2004? (I am running the most recent update.)
Any/all help would be appreciated.
The code I am using is:
Code:
Public Sub posttest()
Dim QT As QueryTable
Dim connstr As String
connstr = "URL;http://127.0.0.1:8080/cgi-bin/posttest.py"
Set QT = ActiveSheet.QueryTables.Add( _
Connection:=connstr, _
Destination:=Range("B1"))
QT.PostText = "quote1=sbux"
QT.Refresh
End Sub