Importing XML through web-based query
 

I'm trying to write a macro to automatically gain access to information via
web services. I recorded the following macro and typed in the
username/password manually when importing:

Sub WebServices()
ActiveWorkbook.XmlImport URL:="http://webpage/products.xml", ImportMap _
:=Nothing, Overwrite:=True, Destination:=Range("$A$1")
End Sub

The problem is that I don't know how to put in the username/password into
the macro so that when I try to run it via the macro (without having the
password already saved), it just gives me a big fat error (Run-time 1004: XML
list is bound to a different XML map).

There will be multiple users for this application so I don't want to have to
go through the hastle of puting in the username/password manually before they
start up the macro. If it's not possible, no worries, they can handle it.
But if it's possible, I'd sure appreciate it. Thanks for any help!

--
-SA