S
StumpedAgain
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!
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!