Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Applescript equivalent to VBA XMLHTTP object?

Having no luck after hours of research on this. Is there an Applescript equivalent to the VBA XMLHTTP object?

We have an Excel form that can pass data to a web service. We basically take the XML, wrap it in a SOAP envelope and send it using the xmlhttp object. Unfortunately, the xmlhttp object does not appear to exist for the mac version of Excel. If there is no equivalent to the xmlhttp object, is there an alternate way of making this work in applescript?

Thanks in advance

Posted on Aug 5, 2009 7:19 PM

Reply
3 replies

Aug 6, 2009 8:19 AM in response to Kennedy27

Thanks guys. We were able to solve the problem through Query Tables in VBA rather than resorting to Applescript.

For anyone interested in the solution:

Sub URL GetQuery()

With ActiveSheet.QueryTables.Add(Connection:= _
"URL; http://mywebservice.com/mywebserviceproc",
Destination:=Range("a1"))

.PostText = SoapString
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub

Lets you post to a web service without using the xmlhttp object

Message was edited by: Kennedy27

Applescript equivalent to VBA XMLHTTP object?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.