ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automate Password log-on (https://www.excelbanter.com/excel-programming/344495-automate-password-log.html)

donbowyer

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


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

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