Calling a Webservice from VBA using SOAP


I'm trying to call a web service in an Excel Macro:

Set objHTTP = New MSXML.XMLHTTPRequest
objHTTP.Open "post", ""
objHTTP.setRequestHeader "Content-Type", "text/xml"
objHTTP.setRequestHeader "SOAPAction", "PutSchedule"
objHTTP.send strXML

And I get back the following response:

  <?xml version="1.0" encoding="utf-8"?>
  <soap:Envelope xmlns:soap="" xmlns:xsi="" xmlns:xsd="">
        <faultstring>Server did not recognize the value of HTTP Header SOAPAction: PutSchedule.</faultstring>
        <detail />

Anybody out there done something like this before?


You SOAP action should also include namespace of the method e.g.


Find out what the namespace of your Service and add it in front of the method name PutSchedule.

By : codemeit

You will probably find it easier to run a second server running Linux than to shoe horn nagios and company into an environment that they were not developed for.

If you do insist on trying to run them in Windows, and if you have lots and lots of problems, please resist the urge to badmouth these products when you have not used them as intended.

By : Glomek

This video can help you solving your question :)
By: admin