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!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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???



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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


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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/