Dynamic Hyperlinking ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

whatwasit@gmail.com - 03 Jul 2006 13:16 GMT

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,

Reply to this Message

HS Hartkamp - 05 Jul 2006 09:12 GMT

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

> Hi,
> I need to burn some files ( Word,PPTs,PDFs, etc) onto a CD.
[quoted text clipped - 6 lines]
>
> Thanks,

Reply to this Message