matching numbers with images?

[Martyn Wilson]

Hello,
I have thousants of numbers written on column A:A referring to different
objects. All thouse objects have similar filenames with numbers written in
column A.
i.e number say 12345 refers to a camera and on the HDD I have the image file
12345.jpg. Is there a macro solution such that when I click on any number in
column A, the image file *.jpg with the same number will automatically
open-up?.
TIA

 

[Frank Kabel]

Hi
put the following formula in column B
=HYPERLINK("C:\temp\" & A1 & ".jpg",A1)
and copy this down for all rows

 

[Martyn Wilson]

Thanks a lot Frank. That did it!.

Hi
put the following formula in column B
=HYPERLINK("C:\temp\" & A1 & ".jpg",A1)
and copy this down for all rows