Launch URL from VBA

[Gary Hillerson]

Can anyone point me to code that will let me launch an URL in the
user's default browser from VBA?

thanks,
gary

 

[Jay Freedman]

Can anyone point me to code that will let me launch an URL in the
user's default browser from VBA?

thanks,
gary

One way is at
http://groups.google.com/[email protected]

Another is at
http://groups-beta.google.com/group...a.beginners/msg/bf700d1ee28481a7?dmode=source
This one uses Internet Explorer explicitly, but it could probably be
modified to local the default browser in the registry and activate
that.

 

[stephenc]

myDummy = Shell("C:\Program files\Internet Explorer\iexplore.exe
http://www.microsoft.com", 1)

See the topc "shell" in VBA online help for details of thr parameters.

Regards,
Stephenc