Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I specify the absolute path?
When using this call:
ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & k), Address:=Range("A" & k).Value, TextToDisplay:=Range("A" & k).Value Is there a way to specify the absolute path, which is what is specified in Range("A" & k).Value? A typical Range("A" & k).Value might be: N:\ENGINEERING\00 - VAULT\Solidworks Files\COMPLETE\0-9\2093,000-2093,999\2093860.SLDPRT When the sheet is all generated, the tool tip shows a relative path. When I go back in and try to change it to absolute using "Edit Hyperlink" (just to see what would happen) it changes itself back. Thank You, -plh -- I keep hitting "Esc" -- but I'm still here! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute path | Excel Discussion (Misc queries) | |||
Absolute Path change ... | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Absolute path ?? | Excel Programming | |||
add-in absolute path | Excel Programming |