Friday, February 12, 2016

Excel VBA- Navigation to a webpage using Internet Explorer

EXCEL VBA TO EXECUTE INTERNET EXPLORER FROM EXCEL

The Internet Explorer application can be executed by using VBA in Excel. In fact, Microsoft Office suite has the feature to invoke one office application from the other one. For example, Word application can be invoked by Excel or PowerPoint or Access etc. The following code can be used if internet explorer is installed on the system to navigate to any specific URL.

Sub pInternetXplorr()

    Dim objIEApp As Object
    Set objIEApp = CreateObject("InternetExplorer.Application")

    With objIEApp
        .Navigate URL:="www.shrishesh.blogspot.in"
        .Visible = True
    End With

    Set objIEApp = Nothing

End Sub


No comments:

Post a Comment

Hot Topics