Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Running Internet Explorer from Excel
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? 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 |
#4
|
|||
|
|||
Thanx for both.
"Wojciech G." wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
windows explorer to excel | Excel Discussion (Misc queries) | |||
Excel and internet reporting! | Excel Discussion (Misc queries) | |||
windows explorer will not open an excel spreadsheet. | Excel Discussion (Misc queries) | |||
Problem opening Excel files from Windows Explorer | Excel Discussion (Misc queries) | |||
How do I print all sheets of an Excel workbook from explorer? | Excel Discussion (Misc queries) |