I have to hyperlink pdfs to a spreadsheet and burn it and the pdfs to a
cd. How do I hyperlink the pdfs if they are on my hard drive and then
transfer them to a cd? The pathnames change and the links become
invalid. I hope I've described my problem correctly. If you need
clarification, please ask.

Thank you so much for your help!


--
kaiser1778
------------------------------------------------------------------------
kaiser1778's Profile: http://www.excelforum.com/member.php...o&userid=31812
View this thread: http://www.excelforum.com/showthread...hreadid=515326

Why not re-direct all of the hyperlinks to cell A1, and then write a macro on
the Worksheet_SelectionChange?

You could then check to see if the file exists on the hard disk, and if not
read from the location you burn it to on the CD?

HTH.

"kaiser1778" wrote:


I have to hyperlink pdfs to a spreadsheet and burn it and the pdfs to a
cd. How do I hyperlink the pdfs if they are on my hard drive and then
transfer them to a cd? The pathnames change and the links become
invalid. I hope I've described my problem correctly. If you need
clarification, please ask.

Thank you so much for your help!


--
kaiser1778
------------------------------------------------------------------------
kaiser1778's Profile: http://www.excelforum.com/member.php...o&userid=31812
View this thread: http://www.excelforum.com/showthread...hreadid=515326