Hyperlink Question?

[ccameron]

Hi Guys,
I have a workbook that I have attached several hyperlinks, I would like to be able to create a compressed folder with the workbook and the photo's I have inserted as hyperlinks, and be able to email the folder to another person and have the hyperlinks work. I currently have to create this on a network folder for it to work, the problem is that some of the people that need to access it work out in the field using laptops.

ANY HELP WOULD BE GREATLY APPRECIATED?

THANKS IN ADVANCE FOR YOUR HELP.

 

[ccameron]

any suggestions would be fantastic?

 

[PA HS Teacher]

Assuming the pictures are stored in the same folder as the spreadsheet, and A1 has the name of the picture file.

Try:
=HYPERLINK(LEFT(CELL("filename"),FIND("[",CELL("filename"))-1)&A1)

The file must be saved for the resulting link to work.

 

[ccameron]

Assuming the pictures are stored in the same folder as the spreadsheet, and A1 has the name of the picture file.

Try:
=HYPERLINK(LEFT(CELL("filename"),FIND("[",CELL("filename"))-1)&A1)

The file must be saved for the resulting link to work.

Thanks PA HS Teacher, I will give it a try.

Thanks again