Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to launch IE from a VBA macro in Excel. After a great deal of
web searching I came up with the following ... Public 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 <some other stuff Sub test23() Dim WEB_SITE_URL As String WEB_WITE_URL = "http://www.mysite.com" Dim SW_SHOWNORMAL As Integer SW_SHOWNORMAL = 1 'Launch Web Site ShellExecute 0, vbNullString, WEB_SITE_URL, vbNullString, _ vbNullString, SW_SHOWNORMAL End Sub When I execute test23 I get a windows explorer window opening up to the My Documents directory. No error messages. I think that I am close. Could someone please help me get this to launch IE. Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB 6.0 to Launch excel | Excel Programming | |||
Launch Excel from the Web | Excel Programming | |||
How to launch one XLA from another on Excel launch | Excel Programming | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
Excel No-Launch | Excel Programming |