HyperLink

[Janet]

From a file on our Infonet, I will to access another Excel
file (also on our infonet)

This is what I have and it works fine on my system but
when I send it to other people (all of who have access to
our infonet) some can use the link others can't - they get
a "Run Time error 9, Subscript out of range." message

We all Run in Office 97



If Range("N3").Value = 1 Then
Workbooks.Open FileName:="http://infonet/Pro/Form
CAD.xls"
ActiveWindow.Visible = False
Windows("Form CAD.xls://infonet/Pro/Form CAD"). _
Visible = True
End If
End Sub

 

[Kevin Beckham]

Janet,
Try
Workbooks("Form CAD.xls").Activate
instead of Windows("...

Kevin Beckham