Say you have your long file name in A12.

Then in B12, put this:

=hyperlink("http:////" & a12,"Click me")

You can use any cell, but I like to use adjacent cells. It makes it easier to
see what's going on.

In fact, if the path is always the same, you could put that in A1:
L:\publicaties\bibliotheek\accreditaties_certifica ties\

Then just put the filename (w/o the path) in A12:
I006-RvA certificaat zwartwit (uk).pdf

And this in B12
=hyperlink("http:////" & $a$1 & a12,"click me")

then if the path changes, you fix A1 and all the formulas get updated.

Corne wrote:

Dave,
thanks for the reply. Your answer worked. I have changed my hyperlink
base to L:\ (our server). Now after saving still the hyperlink address
changes "magically", but with the hyperlink base it works.

Still I like to now how your other proposal works. Can you please help
me with it? Where do I place "=hyperlink() worksheet function"? I must
fill in the path and what must I fill in at "file:////"?

thanks,
corne

--
Corne
------------------------------------------------------------------------
Corne's Profile: http://www.excelforum.com/member.php...o&userid=26346
View this thread: http://www.excelforum.com/showthread...hreadid=396104

--

Dave Peterson