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!

Hello PLH,

Make the Path a String...

MyPath = "N:\ENGINEERING\00 - VAULT\Solidworks\Files\COMPLETE\0-9\2093,000-2093,999\2093860.SLDPRT"

Change Address to...

Address:= MyPath

Hope this helps,
Leith Ross

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 <[email protected]>, 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 <[email protected]>, 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" <[email protected]> wrote in message
news:[email protected]...
> In article <[email protected]>,
> 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!