ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Go to a website and logon automatically (https://www.excelbanter.com/excel-programming/277293-go-website-logon-automatically.html)

excelnewbie

Go to a website and logon automatically
 
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/


Jake Marx

Go to a website and logon automatically
 
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/




excelnewbie

Go to a website and logon automatically
 
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/


excelnewbie

Go to a website and logon automatically
 
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/


Jake Marx

Go to a website and logon automatically
 
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/





All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com