matching numbers with images?
 

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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.720 / Virus Database: 476 - Release Date: 14.07.2004

matching numbers with images?
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Martyn Wilson wrote:
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.720 / Virus Database: 476 - Release Date: 14.07.2004

matching numbers with images?
 

Thanks a lot Frank. That did it!.

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

--
Regards
Frank Kabel
Frankfurt, Germany


Martyn Wilson wrote:
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.720 / Virus Database: 476 - Release Date: 14.07.2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.720 / Virus Database: 476 - Release Date: 14.07.2004