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

[John Williams]

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

 

[Tom Ogilvy]

if
http://username:[email protected]

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

 

[William Lipp]

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.