I have to archive media clippings for my company. I have a list with
hyperlinks to the source files (JPG's, PDF's, ZIP's etc.)

I have different folders for all the source files (according to date) and
want the end-user to have access to those files with a simple click in Excel.

The end-product will be on a CD. As I don't know what their CD drive letter
will be, how can I be certain that the link will guide them to the
corresponding file?

Thank you in advance