title: Calling a Webservice from VBA using SOAP
body: <p>I'm trying to call a web service in an Excel Macro:</p>
  
  <pre><code>Set objHTTP = New MSXML.XMLHTTPRequest
  objHTTP.Open "post", "https://www.server.com/EIDEServer/EIDEService.asmx"
  objHTTP.setRequestHeader "Content-Type", "text/xml"
  objHTTP.setRequestHeader "SOAPAction", "PutSchedule"
  objHTTP.send strXML      
  </code></pre>
  
  <p>And I get back the following response:</p>
  
  <pre><code>  &lt;?xml version="1.0" encoding="utf-8"?&gt;
    &lt;soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
      &lt;soap:Body&gt;
        &lt;soap:Fault&gt;
          &lt;faultcode&gt;soap:Client&lt;/faultcode&gt;
          &lt;faultstring&gt;Server did not recognize the value of HTTP Header SOAPAction: PutSchedule.&lt;/faultstring&gt;
          &lt;detail /&gt;
        &lt;/soap:Fault&gt;
      &lt;/soap:Body&gt;
    &lt;/soap:Envelope&gt; 
  </code></pre>
  
  <p>Anybody out there done something like this before?</p>