N
neowok
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.
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.