sending xml data to a webserver

[gautammalkani]

Hi All

I want to store some xml data in a web server. The xml data is formatted and created in MS excel. I want excel to send the data to a webserver. I have an issue with two things: what is the command to send data? and to log on the webserver, i have to login..is there anyway to hardcode that in Excel as well?

Here is the code of what i have so far:

Sub postASN()
Dim url
Set url = CreateObject("Microsoft.XMLHTTP")
Dim strg, strng As String
strg = ""
strng = ""
Dim dummy As String
dummy = "

http://sampleurl/invoke/knowNow:receiveASNTesting"

url.Open "GET", dummy, False
url.send
End Sub