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!

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 :

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

In article om, keepITcool
says...


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 :

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

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


--
I keep hitting "Esc" -- but I'm still here!

In article om, keepITcool
says...


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 :

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 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


--
I keep hitting "Esc" -- but I'm still here!

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.
"plh" wrote in message
...
In article om,
keepITcool
says...


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 :

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 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


--
I keep hitting "Esc" -- but I'm still here!