Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste Hyperlink result as working hyperlink | Excel Worksheet Functions | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |