I use the method show by Neil here

http://www.google.com/groups?threadm...40tkmsftngxa05

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.

--
Dick Kusleika
MVP - Excel Blog - Daily Dose of Excel
www.dicks-blog.com

" wrote in message
. com...
Nope, I tried that, but it didnt work. I

Any one else have any ideas?

Thanks
"Tom Ogilvy" wrote in message
...
you can try



this is not standard, but some sites support it.

--
Regards,
Tom Ogilvy

" wrote in message
. com...
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