Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code is used in an Excel Macro and when ran in Excel2000
creates a valid hyperlink but in Excel2002 it does not. ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ "\\S10AC52B\Eng\SCN\" & SCNFile, TextToDisplay:= _ "" & SCNNumber When SCNFile is set equal to "3PH-04011.xls" the hyperlink url that's created in Excel2000 looks like " \\S10AC52B\Eng\SCN\3PH-04011.xls" but when created in Excel2002 it looks like "..\..\Eng\SCN\3PH-04011.xls" Anyone have an idea as to why excel would change the url? How can I make it work correctly? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel2002 | Setting up and Configuration of Excel | |||
Text book Excel2002 VBA | Excel Discussion (Misc queries) | |||
HYPERLINK URL PROBLEM (Excel2000 VS Excel2002) | Excel Programming | |||
VBA and comments in Excel2002 | Excel Programming |