Dynamic Hyperlinking ?

[whatwasit]

Hi,
I need to burn some files ( Word,PPTs,PDFs, etc) onto a CD.
These are referenced using hyperlinks in excel.
Is there a way to maintain the hyperlink while burning the CD, so that
the hypelinks still work while on the the CD ??

Also, is there a way to embed Word/PDF/PPT files into an Excel Sheet
and then Hyperlink it. So it all is stored in One BIG excel file .


Thanks,

 

[HS Hartkamp]

Create a user function resulting in the path / filename of the excel sheet,
and use that in your hyperlink destination. That way, if the files on CD are
in the same (relative) location, it should still work after burning.

Bas Hartkamp