+ Reply to Thread
Results 1 to 3 of 3

need to edit macro for auto login, replaced from internet explorer to google chrome

  1. #1
    Forum Contributor
    Join Date
    01-07-2014
    Location
    chandigarh
    MS-Off Ver
    Excel 2010
    Posts
    122

    Question need to edit macro for auto login, replaced from internet explorer to google chrome

    Hello Friends !!
    Here I need one assistance from the experts. Below given is the code that opens the web link in INTERNET EXPLORER & simultaneously adds username and password as well in the required fields, Now I want application of INTERNET EXPLORER to be replaced by GOOGLE CHROME, I tried several methods but all in vain can anyone help me in this

    Sub internetlogon()
    Dim IE As Object
    Set IE = CreateObject("InternetExplorer.application")
    IE.Visible = True
    'Go to this Web Page!
    IE.Navigate "https://www.linkedin.com/m/login/"
    'Check for good connection to web page loop!
    Do
    If IE.ReadyState = 4 Then
    IE.Visible = False
    Exit Do
    Else
    DoEvents
    End If
    Loop
    'Wait for window to open!
    Application.Wait (Now + TimeValue("0:00:01"))
    IE.Visible = True
    'Send logon information
    SendKeys "xxxxxusernamexxxxx", True
    SendKeys "{TAB}", True
    SendKeys "xxxxxpasswordxxxxx", True
    End Sub


    Thanks n Regards

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: need to edit macro for auto login, replaced from internet explorer to google chrome

    Try this: From Chrome (if the username & password is already saved in Chrome) Try this
    Please Login or Register  to view this content.
    Last edited by Syrkrasi; 11-22-2017 at 03:19 PM. Reason: Edit Chrome Info

  3. #3
    Forum Contributor
    Join Date
    01-07-2014
    Location
    chandigarh
    MS-Off Ver
    Excel 2010
    Posts
    122

    Re: need to edit macro for auto login, replaced from internet explorer to google chrome

    Quote Originally Posted by Syrkrasi View Post
    Try this: From Chrome (if the username & password is already saved in Chrome) Try this
    Please Login or Register  to view this content.
    Hi.
    I tried the code but its not producing the desired result rather ends up with error 91 while running could you please check what is wrong with this code

    Sub internetlogon()
    Dim IE As Object
    Shell ("C:\Program Files (x86)\Google\Chrome\Application\Chrome.exe -url https://www.linkedin.com/uas/login?session_redirect=%2Fvoyager%2FloginRedirect%2Ehtml&fromSignIn=true&trk=uno-reg-join-sign-in")
    IE.Visible = True
    'Go to this Web Page!
    IE.Navigate "https://www.linkedin.com/m/login"
    'Check for good connection to web page loop!
    Do
    If IE.ReadyState = 4 Then
    IE.Visible = False
    Exit Do
    Else
    DoEvents
    End If
    Loop
    'Wait for window to open!
    Application.Wait (Now + TimeValue("0:00:01"))
    IE.Visible = True
    'Send logon information
    SendKeys "XXXXUSERNAMEXXXX", True
    SendKeys "{TAB}", True
    SendKeys "XXXXPasswordXXXX", True
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-07-2014, 08:33 PM
  2. change from Internet Explorer to Google Chrome
    By aikz007 in forum Excel General
    Replies: 6
    Last Post: 11-10-2014, 03:38 AM
  3. Goolge Chrome Auto-Login
    By cbatten01 in forum Excel General
    Replies: 2
    Last Post: 03-23-2014, 03:59 PM
  4. How do I open with Chrome and not Internet Explorer?
    By walterscj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 11:13 AM
  5. [SOLVED] Internet Explorer - Website(s) programmatic login fails
    By J450n in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2012, 08:08 PM
  6. Internet explorer + Google Searching VBA
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2012, 05:38 PM
  7. macro to auto open internet explorer
    By mbcebrian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2011, 12:49 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1