Moving Files After Hyperlink

[Kenneth]

I have built an inventory and created a hyperlink to each item'
picture. The hyperlink references the picture in a folder on my har
drive. I want to save this spreadsheet and the pictures to a CD, an
have the hyperlink point to the new folder/file on the CD. Any way t
do this, or must I edit all the hyperlinks individually

 

[Earl Kiosterud]

Kenneth,

If you can, have the folder contained in the folder the workbook has been
saved in. The hyperlink should now be:
MyFolder\MyPicture.jpg. Note no \ in front of it -- it's relative to the
folder the workbook is in. That's the key. If the workbook and folder are
written to the CD, then to another machine, and the workbook is still in the
parent folder of the picture folder, I think it will work.