Insert hyperlink with another application

S

snr

I have a excel spreadhseet containing a hyperlink column, showing the
path to a jpeg file. When I click on the hyperlink I would like it to
open the jpeg file using an imaging application. I would like to repear
this for a vast amount of data so that I don't have to insert objects
for each individual record.

Any response would be appreciated.

Thanks
 
D

David McRitchie

You can use the HYPERLINK Worksheet Function
if your .jpg file extension is registered to the software you want
to open it.
 
D

Dave Peterson

How about using a worksheet formula?

If column A held the full name of the .jpg file (including drive, path), then a
formula like this might work ok:

=hyperlink(a1)
or
=hyperlink(a1,"click to open")


But this will open the windows program that is associated with .jpg.

And you didn't ask, but there's a neat freeware program that might make your
foray into excel for graphics moot.

http://www.irfanview.com/
 
Top