hi,
i'm attempting to create a CD for mass production. the CD will contain a lot of reference images.
i plan to create an index file in excel, which i will then convert to HTML. the idea is that when you click on the image's name in the index, the image itself will come up.
this would be easy if everybody had their CD-ROM assigned to the same drive letter. then, i could just create a formula like
=HYPERLINK(file:///d:\Scanned Images\001-028\image003.tif,Image003)
the problem is, that "d:" won't be everybody's CD-ROM. is there a way to express something like "CurrentDrive" in the file path?
or, is it possible that i am attempting to go about this completely the wrong way? any help would be appreciated.
ryan supak
i'm attempting to create a CD for mass production. the CD will contain a lot of reference images.
i plan to create an index file in excel, which i will then convert to HTML. the idea is that when you click on the image's name in the index, the image itself will come up.
this would be easy if everybody had their CD-ROM assigned to the same drive letter. then, i could just create a formula like
=HYPERLINK(file:///d:\Scanned Images\001-028\image003.tif,Image003)
the problem is, that "d:" won't be everybody's CD-ROM. is there a way to express something like "CurrentDrive" in the file path?
or, is it possible that i am attempting to go about this completely the wrong way? any help would be appreciated.
ryan supak