Feb 20

#1:Connect to Internet Explorer(IE) via VBA

VBA Intermediate: 

#1:Connect to Internet Explorer(IE) via VBA

Solution: 

1. Using Late binding methodology create object of IE and make the visible property as true. 

2. Then Navigate to your URL 

Benefits: 

  1. Automate your day to day work

  2. Save your time

  3. Increase your productivity

Alternatively you can watch my below video for better clarity 

If the video is not visible please Click Here

You can download the file by Clicking Here.

Please leave your comments below if this tip is useful.

1 comment

    • sushma on December 13, 2017 at 11:09 am
    • Reply

    Hi All,
    I’m trying to login to a website using the macros but at the login page in the user name box I’m not able to write the user name.
    can any one help
    Sub search()

    Dim IE As Object
    Dim HTMLDoc As HTMLDocument
    Dim MyHTML_Element As IHTMLElement

    ‘On Error GoTo error_handler
    Application.EnableEvents = True
    Set IE = CreateObject(“InternetExplorer.Application”)

    With IE
    .navigate “https:/#####.com/login”
    IE.Visible = True
    End With
    Do
    DoEvents
    Loop Until MyBrowser.readyState = READYSTATE_COMPLETE

    Set HTMLDoc = MyBrowser.document

    HTMLDoc.all.userName.Value = “abcd”
    HTMLDoc.all.password.Value = “1234”
    If MyHTML_Element.Type = “submit” Then MyHTML_Element.Click

    Exit Sub

    ‘error_handler:
    ‘MsgBox (“Unexpected Error, I’m quitting.”)

    ‘Set objIE = Nothing

    End Sub

Leave a Reply

Your email address will not be published.