Thanks for the many responses. They were all helpful. This response from
Tim seems like the perfect solution to my problem.

Thanks again to Tim and everyone else who responded.

Bob

"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
activeworkbook.followhyperlink "http://www.google.com"

Tim


"eBob.com" wrote in message
...
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