troubleshooting Question

MSXML2.ServerXMLHTTP authentication

Avatar of PraKash
PraKash asked on
Microsoft Excel
6 Comments1 Solution2270 ViewsLast Modified:
I am trying a basic web services call. I tried this through SOAP UI and gave the login and password as request properties and it works. How can I simulate this excel macro?

I tried the following:

    xmlhttp.setRequestHeader "Man", Post & " " & "https://" & Server & " HTTP/1.1"
    xmlhttp.setRequestHeader "MessageType", "CALL"
    xmlhttp.setRequestHeader "Content-Type", "text/xml"
    xmlhttp.setRequestHeader "Username", UserName
    xmlhttp.setRequestHeader "Password", Password

It did not work. I also tried to append the username and password along with the server and still did not work.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros