Automate "Get External Data" over HTTP with a BasicAuth protectedressource

[=?ISO-8859-1?Q?Michael_Kr=F6ll?=]

Hi,

Using the "Get External Data" import dialog of Access 2003 I can import
an XML file from a remote URL. If a that URL needs credentials
(BasicAuth), I'll be prompted for username and password and the import
works fine. Now, if I try to automate that process using
Application.ImportXML that import fails. It looks like ImportXML only
accepts unprotected URLs.
How can I workaround that? Are there other ways to automate that "Get
External Data" import dialog? Do I have to use WinHTTPRequest and ask
for username and password via InputBoxes?

--michael

 

[Joe Fallon]

There used to be a syntax for embedding credentials in the URL itself.
Not sure if MS removed it in a recent SP.
But give it a try.

I don't recall the exact syntax off the top of my head but it was something
like:

http://joe:[email protected]

 

[Douglas J. Steele]

That capability was removed from Internet Explorer quite some time ago, so
I'd assume the same is true of the Get External Dialog route as well.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

There used to be a syntax for embedding credentials in the URL itself.
Not sure if MS removed it in a recent SP.
But give it a try.

I don't recall the exact syntax off the top of my head but it was
something like:

http://joe:[email protected]

 

[Guest]

I don't recall the exact syntax off the top of my head but it was something
like:

http://joe:[email protected]

Worked perfectly. Thx!

--michael