Opening IE from Excel
To open a web page in a seperate window, call this function with your URL – for example openbrowser(“http://www.e-ms.ie”)
Function OpenBrowser(tmpURL)
Dim Browser As Object
Set Browser = CreateObject("InternetExplorer.Application")
Browser.Navigate (tmpURL)
Browser.StatusBar = False
Browser.Toolbar = False
Browser.Visible = True
Browser.Resizable = False
Browser.AddressBar = False
End Sub

Leave a Reply
Want to join the discussion?Feel free to contribute!