Running Internet Explorer from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Hi Wojciech,
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?
Click to expand...

Personally, I just use ShellExecute, so it launches in the whatever browser
the user has set up:

Private Const WEB_SITE_URL As String = "http://www.mysite.com"
Private Const SW_SHOWNORMAL = 1
Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Private Sub lblWebSite_Click()
'Launch Web Site
ShellExecute 0, vbNullString, WEB_SITE_URL, vbNullString, _
vbNullString, SW_SHOWNORMAL
End Sub


Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev
 
Back
Top