Hyperlink Help Urgent

  • Thread starter Thread starter kaiser1778
  • Start date Start date
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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking pdfs to a master or primary document 1
Hyperlinks to pdfs and word documents are not working 1
Hyperlink failure after saving document 2
Hypeerlinks in worksheet changed locations from server to workstat 1
how to prevent excel to change hyperlink path towards external fil 3
Printing hyperlinked Documents 1
How to chanage directory to mapped network drive? 2
Open specific hyperlink (accept) automatically in email with outlook 0

Back
Top