hyperlinks - absolute path refuses to stay!!!!

From: neowok (neowok.11tm5b_at_excelforum-nospam.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 05:54:49 -0600

i have a whole bunch of hyperlinks to various files and folders that i
need kept absolute because sometimes users will copy my workbook to a
disk and run it off the disk, meaning any relative paths will not
work.

so after looking around ive basically concluded the only way to enter
an absolute path into a hyperlink in excel is to manually go and look
at the entire directory structure, and then manually type in the exact,
absolute path (which is a long path!).

The problem is i just did that, went off to look at a coupe of other
things, come back and the link which *DID* work now no longer works and
the bluddy thing has inserted loads of ..\..\..\..\ where i typed in
the absolute path!!!!!

This is absolutely rediculous, there appears to be no way what so ever
to 1: get the absolute path used in the first place, and 2: KEEPING the
goddamn hyperlink using the SAME bluddy path that you just had to go
and type in manually.

I know you can set a 'hyperlink base address' for all hyperlinks in the
workbook. This is useless because i have some hyperlinks to webpages,
and a load of hyperlinks to files in various folders on this network
drive.

i must be missing something because nobody would be stupid enough to
have designed it like this, not EVEN MS. 

---
Message posted from http://www.ExcelForum.com/