title: Excel VBA using XMLHTTP with Siteminder Secured site
body: <p>I am completely new to using XMLHTTP and experimenting with trying to download a report off of our company's internet site using Excel VBA. The problem I seem to be running into is that the site is protected by Siteminder. I think I need to use an XMLHTTP.Open with GET but anyway I try all I just seem to get is the Siteminder HTML code. So I am trying to first use a post to send my username and password to Siteminder something like:</p>
  
  <pre><code>Function PostXmlData(vUrl As String, UserName As String, Password As String, xmlText     
  As String
  Dim XMLHttp As Object
  Set XMLHttp = CreateObject("MSXML2.XMLHTTP")
  XMLHttp.Open "POST", vUrl, False, UserName, Password
  XMLHttp.setRequestHeader "Content-Type", "text/xml;charset=utf-8"   
  
  XMLHttp.send (xmlText)
  PostXmlData = XMLHttp.responseText
  End Function
  
  Sub Posttest ()
  Dim add As String
  Dim User As String
  Dim Pass As String
  Dim send As String
  Dim ret As Variant
  
  add = "https://mycompanywebsite.com/apps/application/Main/"
  User = "username"
  Pass = "password"
  Send="DashboardId=http://mycompanywebsite.com/DAVCatalog/Dashboards/Teams/Client%20_
  Extranet%20AM"
  
  ret = PostXmlData(add, User, Pass, send)
  End Sub
  </code></pre>
  
  <p>Am I on the right track or is this not even possible? Any suggestions would be greatly appreciated or if there is some site someone could direct me to that would be helpful. THanks.</p>