Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Password log-on
I'm using the code below from an earlier posting to log on to the web and
navigate to a particular page. With ie .Visible = False .Navigate "https://somepage.com" Do Until Not .Busy DoEvents Loop EndWith It works OK but the page I'm trying to open has a User Name/Password DialogBox which although pre loaded and saved with the appropriate data still needs a non automated click on the Submit button. How can I automate this? From the same earlier posting I have tried the following Set ipf = IE.Document.all.Item("User Name") ipf.Value = "myUserID" Set ipf = IE.Document.all.Item("Password") ipf.Value = "1234" Set ipf = IE.Document.all.Item("but_login") '??? ipf.Click but get an error message "method 'Document' of object 'IWebBrowser2' failed" Any suggestions would be greatly appreciated. -- donwb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use a macro to automate excel worksheet password protection | Excel Discussion (Misc queries) | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Comparing password entry vs stored password - 2003 | Excel Programming | |||
Automate Password Protection for Excel | Excel Programming |