display data from a website in excel that requires a username/password
 

Hi,

I need help, i need to open a website that requires a username and
password. I know how to open up a site in excel that does not require
this, I am hoping theres some VBA syntax that allow you to put in the
username/password into the program which will automatically log you
onto the site

thanks

display data from a website in excel that requires a username/password
 

if


doesn't work then there isn't any builtin, predefined/standard solution that
I have ever seen posted.

--
Regards,
Tom Ogilvy


"John Williams" wrote in message
m...
Hi,

I need help, i need to open a website that requires a username and
password. I know how to open up a site in excel that does not require
this, I am hoping theres some VBA syntax that allow you to put in the
username/password into the program which will automatically log you
onto the site

thanks

display data from a website in excel that requires a username/password
 

On 11 Nov 2004 11:37:05 -0800, (John Williams)
wrote:

i need to open a website that requires a username and
password.

This can often be solved as a separate web query to perform the logon.
The logon usually has a form that is submitted through post or get.
Send that web query, then send the data request.