Hyperlink Help Urgent

K

kaiser1778

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!
 
D

DaveO

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.
 
Top