MSXML2.ServerXMLHTTP authentication

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.
PraKashAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jkpieterseCommented:
Hi Prakash,
It looks like you haven't posted your entire code, could you do that please? Some essential parts are missing to make this work.
0
PraKashAuthor Commented:
well, I was going ask for the code to make a basic authentication. I can do this through SOAP UI. But I want to know how to replicate the SOAP UI authentication. I can send the data over but it comes back saying have to send session ID or login information.
0
jkpieterseCommented:
I still have to see your complete code including the line that generates the error. Maybe something important is missing. Also, have a look at this question:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_25609912.html
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

PraKashAuthor Commented:
Let me rephrase my question. How can I make SOAP calls to a web service that accepts basic authentication? I can make these calls through SOAP UI but when I try that from macros its giving me no SOAPAction Header! error.

I dont ahve the code yet. The ones that I pasted in front were the first few lines that I have
0
PraKashAuthor Commented:
I figured it out myself. Thanks.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jkpieterseCommented:
Would you like to share the solution so others may learn?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.