Go to a website and logon automatically

[excelnewbie]

Hello,


I know that it is possible to have code to go to a website and dowload
a file, but can you do that to a website that you need to logon to??
Can you code in the user name and password to be entered
automatically????

Any suggestions would be appreciated!

Thanks!

 

[Jake Marx]

Hi excelnewbie,

Yes, it's possible, but it's not easy in some cases. Try reading this
thread for starters:

http://tinyurl.com/np1t


Regards,

Jake Marx
MS MVP - Excel

 

[excelnewbie]

Thank you Jake! I will check it out and see if I can get it to work!

 

[excelnewbie]

Hi Jake,

I tried the code but I get:

Run-time error '438'
Object doesn't support this property or method.

When it reaches this line of code....

With .Document.all.loginscreen

Am I missing a reference?? any suggestions???

 

[Jake Marx]

Hi,

That must be a Javascript error being generated from the web page.

I think Hotmail has changed their logon page (more than once) since that
code was posted. I meant for that thread to be more of a learning reference
than a code snippet. I swear it used to work. <g>

The general things you need to know are the URL and the Form elements on the
web page (including type="hidden" ones that you can't see).

Regards,

Jake Marx
MS MVP - Excel