Can I specify the absolute path?

[plh]

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

 

[keepITcool]

I'm guessing here..

can it be that you've defined a hyperlink base address for the workbook?
see File/Properties, bottom of the Summary page has this field.
if filled try clearing it.

hth


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


plh wrote :

 

[plh]

I'm guessing here..

can it be that you've defined a hyperlink base address for the workbook?
see File/Properties, bottom of the Summary page has this field.
if filled try clearing it.

hth


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


plh wrote :

No, that's not it. Already clear. The text displayed comes up as an absolute
path. But the link itself is relative. This even thought the values plugged in
are the same (Range("A" & k).Value).
Thanks,
-plh

 

[plh]

I'm guessing here..

can it be that you've defined a hyperlink base address for the workbook?
see File/Properties, bottom of the Summary page has this field.
if filled try clearing it.

hth


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


plh wrote :

I just noticed this: In the "Edit Hyperlink" subwindow, the both the "Text to
display" text box and the "Type the file or Web Page name" show the relative
path (example):
\\engineering\Solidwork-n\ENGINEERING\00 - VAULT\Solidworks
Files\COMPLETE\0-9\2230,000-2239,999\2239213.SLDPRT
but what you see in the blue underlined text on the spreadsheet is the absolute
path (example):
N:\ENGINEERING\00 - VAULT\Solidworks
Files\COMPLETE\0-9\2230,000-2239,999\2239213.SLDPRT
This would not be a problem except that on other computers besides my own, Excel
can't resolve the link.
Thanks,
-plh

 

[Tig]

I experienced the same problem. The way I fixed it is to create a trigger
event. Run a macro to write absolute path when the workbook is opened or
worksheet is changed.