View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nick Hebb Nick Hebb is offline
external usenet poster
 
Posts: 162
Default Followhyperlink using specific web browser

Oreg,

Here's some sample code:

Dim sPath As String
Dim sURL As String
Dim dTaskID As Double

sPath = "c:\program files\mozilla firefox\firefox.exe" 'my browser
sURL = "http://www.breezetree.com" 'shameless plug

dTaskID = Shell(sPath & " " & sURL, vbNormalFocus)

If dTaskID = 0 Then
MsgBox "Could not open browser"
End If


The key part for you will be determining the path of the netscape.exe
program. If everyone has the shared drive mapped to "F:" then it's no
problem, but most likely you'll need to get the UNC path for the drive.

The UNC would look like:
\\Server Name\Program Files\Netscape\Communicator\Program\netscape.exe

Where "Server Name" is the name of the shared drive. Also note that I
didn't use the follow_hyperlink event. You can just the put code in the
button's click event.

HTH,

Nick Hebb
BreezeTree Software
http://www.breezetree.com