Automatic Hyperlink Multiple Photos Outside Excel?

Hi,
I have and Excel doc for which I need to hyperlink 1000+ photos for viewing.
I need to automate this hyperlinking.

For instance:

The Photos are on C:\\Photos\
and the Excel files is C:\\testfile.xls

The final product is the Photos and Excel file will reside on a compact disc as Folder(photos) and Excel File.

The photos will pop up in default viewer from hyperlink.

I have searched but can not find the answer

Thank you for your assistance,
Andre

Try this macro

Please Login or Register  to view this content.