With Excel for windows I can succesfully send a string of data to a remote server and retrieve the response with the following code:
This does not work on Excel for Mac since MSXML2.ServerXMLHTTP is not implemented on that platform.
What would be the way to do this on a Mac version of Excel?
From what I've gathered the strategy would be to implement some sort of curl command
Has anyone here got anything like this succesfully implemented with Excel Mac?
VBA Code:
dim URL as string , Rsp as string, ObjHTTP as object
Set ObjHTTP = CreateObject("MSXML2.ServerXMLHTTP")
URL = "https://Somesite.com/xxxyyy?" & myData
ObjHTTP.Open "POST", URL, False
ObjHTTP.setRequestHeader "Content-type", "application/json"
ObjHTTP.Send (Json)
Rsp = ObjHTTP.responsetext
This does not work on Excel for Mac since MSXML2.ServerXMLHTTP is not implemented on that platform.
What would be the way to do this on a Mac version of Excel?
From what I've gathered the strategy would be to implement some sort of curl command
VBA Code:
curl --data "param1=value1¶m2=value2" http://hostname/resource
Has anyone here got anything like this succesfully implemented with Excel Mac?