J
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
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