Internet Explorer Auto Login To Google Or Other Page

[ExcelJunkie]

Here is a short but sweet script to login to i-Google. Script could be changed to suit a variety of needs. Beware of pages that have login objects located within a frame. That gets a little bit trickier. To change to other sites simply change web address, and ie form object names to match that of your login page. To get these go to your login page, right click view source, and get form object ids.
Enjoy

 
Sub IGoogle_AutoLogin() 
    Set ie = CreateObject("InternetExplorer.application") 
    ie.Visible = True 
    ie.navigate ("https://www.google.com/accounts/ServiceLogin?service=ig&passive=true&continue=http://www.google.com/ig%3Fhl%3Den&followup=http://www.google.com/ig%3Fhl%3Den&cd=US&hl=en&nui=1&ltmpl=default") 
    Do 
        If ie.readyState = 4 Then 
            ie.Visible = True 
            Exit Do 
        Else 
            DoEvents 
        End If 
    Loop 
     
     'USE VIEW SOURCE TO GET FORM ELEMENT IDS
    ie.Document.forms(0).all("Email").Value = "yourvalue here" 
    ie.Document.forms(0).all("Passwd").Value = "yourvaluehere" 
    ie.Document.forms(0).submit 
End Sub 

http://www.ozgrid.com/forum/showthread.php?t=81063

[Dave Hawley]

Thank you!

[Wigi]

Nice, thanks ExcelJunkie.