This article contains an example of using late binding to create a new instance of Internet Explorer.
Please note that you can copy these code examples into any application that supports VBA, but the called application must be installed on your system for it to work. Just copy them into a standard module and run them. (No references need to be set in the Visual Basic Editor in order to make this code work.)
This code will create a new instance of Internet Explorer and bind to it. It will then navigate to the ExcelGuru Excel Pages index. You cannot use the GetObject method used for the rest of the applications to bind to an existing Interent Explorer instance.
Sub GetInternetExplorer() 'Author : Ken Puls (www.excelguru.ca) 'Create an instance of Microsoft Internet Explorer Dim objApp As Object 'Create instance and set to visible On Error GoTo ErrHandler Set objApp = CreateObject("InternetExplorer.Application") With objApp .Visible = True End With 'Add some text to the document With objApp .Navigate URL:="http://www.excelguru.ca/ExcelPages.htm" End With ErrHandler: 'Release the object and resume normal error handling Set objApp = Nothing On Error GoTo 0 End Sub