Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Internet Explorer Auto Login To Google Or Other Page

  1. #1
    Join Date
    17th January 2007
    Posts
    48

    Talking Internet Explorer Auto Login To Google Or Other Page

    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

    VB:
     
    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
    Last edited by Dave Hawley; December 20th, 2007 at 10:27.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

  3. #3
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,068

    Re: Internet Explorer Auto Login To Google Or Other Page

    Nice, thanks ExcelJunkie.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno