Re: Automate "Get External Data" over HTTP with a BasicAuth protected ressource

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
http://I.Am/DougSteele
(no e-mails, please!)



"Joe Fallon" <jfallon1@xxxxxxxxxxxxxxxxxx> wrote in message
news:%239gi$yx8FHA.2364@xxxxxxxxxxxxxxxxxxxxxxx
> 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:pwd@xxxxxxxxxx
>
>
> --
> Joe Fallon
>
>
>
>
> "Michael Kröll" <michael.kroell@xxxxxxxxxx> wrote in message
> news:438727fb$1@xxxxxxxxxxxxxxxxx
>> 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
>>
>> --
>> 063A F25E B064 A98F A479 1690 78CD D023 5E2A 6688
>> http://zis.uibk.ac.at/.m/uibk.ac.at_pgp_pubkey.asc
>
>


.

Relevant Pages

  • How to automate web login?
    ... Trying to automate a web login (username and password) to a Yahoo group. ... Dim IeApp As InternetExplorer ... Dim sURL As String ...
    (microsoft.public.excel.programming)
  • How to automate web login?
    ... Trying to automate a web login (username and password) to a Yahoo group. ... Dim IeApp As InternetExplorer ... Dim sURL As String ...
    (microsoft.public.vb.general.discussion)
  • Re: microsoft terminal server
    ... i would like to know if there is a way to create a python script for ... automate mstsc.exe username and pwd credential, ... to store your username / password and use an .rdp ...
    (comp.lang.python)
  • Re: Automate Task scheduler password change
    ... > button at the Run as field of each jobs in my task scheduler. ... You may not need to automate this after all. ... one password for every different UserName. ... from the GUI, only the creator. ...
    (microsoft.public.win2000.general)