Running Internet Explorer from Office VB

[ranc]

Hi,

How can I open an Internet Explorer window (even if it's not the default browser) using VBA ?

10x,
Ran
ran@swapstation.com

 

[dsi]

You can use the CreateObject function generically:

Sub StartIE()
Dim MyWeb As Object
Set MyWeb = CreateObject("InternetExplorer.Application&quot
MyWeb.Visible = True
MyWeb.navigate "

http://www.microsoft.com"

End Sub

Or, you can use the Internet Explorer Object. From Excel Go to Tools>References and add Microsoft Internet Controls. Then you can use this format. (I think this method is easier to use.)

Sub StartIE2()
Dim ie As InternetExplorer
Set ie = New InternetExplorer
ie.Visible = True
ie.AddressBar = True
ie.Navigate ("

http://www.microsoft.com")

End Sub

Although I did this in Excel, it should work in any Office VBA macro, assuming you add the reference to MS Internet Controls.

Hope this helps!