matching numbers with images?

  • Thread starter Thread starter Martyn Wilson
  • Start date Start date
M

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
 
Hi
put the following formula in column B
=HYPERLINK("C:\temp\" & A1 & ".jpg",A1)
and copy this down for all rows
 
Thanks a lot Frank. That did it!.

Frank Kabel said:
Hi
put the following formula in column B
=HYPERLINK("C:\temp\" & A1 & ".jpg",A1)
and copy this down for all rows
Click to expand...
 
Back
Top