No need to worry about IE's path. Set a reference to Microsoft
Internet Controls then use something like:
Option Explicit
Sub test_VBA_and_IE()
Dim x As InternetExplorer
Set x = New InternetExplorer
x.Visible = True
x.Navigate "www.nytimes.com"
Do While x.ReadyState < READYSTATE_COMPLETE: DoEvents: Loop
End Sub
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
How to run IE and go to specified webside from a VBA macro. But, WITHOUT
giving a IE's path ? It seems to be simly, but I tried even API without any
success
= how to get IE's path?