Thread: HyperLink
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Janet[_5_] Janet[_5_] is offline
external usenet poster
 
Posts: 2
Default HyperLink

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