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!