View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Absolute hyperlink

You could try changing the hyperlink base to c:\.

File|properties|summary tab

But I'd use the =hyperlink() worksheet function. I've never seen it fail.

=hyperlink("File:////\\server\path\filename.ext","Click me")



Robert wrote:

Gents I'm using VBA in Excel to created hyperlinks to files. VBA
creates absolute hyperlinks and this works fine. But when I save the
file on the same server it changes the hyperlink from absolute to
relative, which conflicts with other features in my VBA code. Could
anybody please help me with this?


--

Dave Peterson