Saving Hyperlinks

[Guest]

Hi, I'm am trying to link pictures to hyperlinks in Excel 2000. The links
worked fine for awhile, then stopped working. But my main question is, how
would I save the Excel file to link to the images when burned to a CD? Since
you can't re-link them on a CD, because you can't save, and I can't create a
path in "Properties" because I don't know what every persons drive
(D,E,etc...) is going to be when they put in the CD.

Is there anyway I can make this work?

Thanks.

 

[Guest]

Here is a tiny trick that will work with CD players or any mapped drive. Say
we like to a picture on the C drive as follows:

=HYPERLINK("file:///c:/sample.jpg","Sample")

but the c:/ may change in the future. Use instead:

=HYPERLINK("file:///"&A1&":/sample.jpg","Sample")

and tell the use to enter the drive letter in cell A1. This way its the
user that determines the drive to use.