Insert hyperlink with another application

  • Thread starter Thread starter snr
  • Start date Start date
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
 
You can use the HYPERLINK Worksheet Function
if your .jpg file extension is registered to the software you want
to open it.
 
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/
 
Back
Top