e-mailing linked files

[tezmo king]

Hi, I have an Excel spreadsheet with a hyperlinked image (.tif) on each
row, total of 85 rows. The image opens when clicked.

How can I e-mail the spreadsheet file and transport the linked files
(images) with it so that it will ope nin the same way for the
receiver??
tezmo

 

[Nick Hodge]

Tezmo

They will work if the receiver put them in the same named folder in the same
location. Alternatively, you will have to write some code that on opening
the workbook, asks the user for the destination folder of the images and
changes all the hyperlink addresses