Rocky Swartz
New Member
- Joined
- Aug 25, 2005
- Messages
- 15
I am currently having problems using ActiveX components in my VBA code on MacOS.
Specifically with:
Dim oXMLHTTP As Object
Set oXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")
oXMLHTTP.Open "POST", "URL.....", False 'Set Open Posts For Text MyBody = "{Content}" 'Request Body For Text Response oXMLHTTP.SetRequestHeader "Content-Type", "application/json" 'Set Header Type oXMLHTTP.SetRequestHeader "Authorization", "User " & apiKey 'Set Header Authorization Debug.Print MyBody oXMLHTTP.Send MyBody Response = oXMLHTTP.responseText
Can anyone assist in providing AppleScript that can be inserted to emulate this procedure in VBA for MacOS
Specifically with:
Dim oXMLHTTP As Object
Set oXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")
oXMLHTTP.Open "POST", "URL.....", False 'Set Open Posts For Text MyBody = "{Content}" 'Request Body For Text Response oXMLHTTP.SetRequestHeader "Content-Type", "application/json" 'Set Header Type oXMLHTTP.SetRequestHeader "Authorization", "User " & apiKey 'Set Header Authorization Debug.Print MyBody oXMLHTTP.Send MyBody Response = oXMLHTTP.responseText
Can anyone assist in providing AppleScript that can be inserted to emulate this procedure in VBA for MacOS
