Web Query Logins and Access Refresh

[neyoisles]

I want to create a web query to a page that requires a login and password.
Is it possible to store the id and password in vb so that the spreadsheet
will automatically login to the web page? I also have this spreadsheet
linked from access. Id like access to automatically refresh the data in the
spreadsheet. Is this possible with code?Thanks

 

[Tom Ogilvy]

you can try

http://username:[email protected]

this is not standard, but some sites support it.

 

[neyoisles]

Nope, I tried that, but it didnt work. I

Any one else have any ideas?

Thanks

 

[Dick Kusleika]

I use the method show by Neil here

http://www.google.com/groups?threadm=a0f101c24eb2$52a1b5f0$9ee62ecf@tkmsftngxa05

I haven't figured out how to do it in the user-interface (nor have I tried),
so I save the query as an iqy and edit it in Notepad. Note that the line
that starts with OpenView and the next line should be all one line. Also,
you don't need to enter prompt brackets, but can enter literal values. They
won't be secure from prying eyes, however.