Absolute hyperlink

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

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?
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks property return a relative path ... 5
Absolute vs. relative hyperlinks 5
Hyperlinks getting changed on save 1
Open specific hyperlink (accept) automatically in email with outlook 0
UDF that returns a Hyperlink 6
No program is registered to open this file 1
wrong Hyperlink-Values 1
Will not auto open .jpg 1

Back
Top