Is it possible to click on a picture in excel and have it open with Windows Photo Viewer?
Windows7
Excel 2010
Z
Is it possible to click on a picture in excel and have it open with Windows Photo Viewer?
Windows7
Excel 2010
Z
Last edited by zplugger; 01-29-2013 at 09:16 AM.
double post.
Last edited by xenixman; 01-26-2013 at 02:47 PM.
You would have to use a =HYPERLINK() command:
With your picture Name in Cell A1 (make sure there are no spaces in the name to make life easier)
The =HYPERLINK() has two parts:
The actual Link: "C:\Users\Mike\Documents\Mom\"&A1&".jpg" which is the complete PATH to the file
and
The Display Name. I have used cell A1, which should contain the file name.
You can use a text string if you want.
=HYPERLINK("C:\Users\Mike\Documents\Mom\"&A1&".jpg",A1)
where A1 is just the File Name with NO extension: Scan1
or something like:
=HYPERLINK("C:\Users\Mike\Documents\Mom\"&A1,A1)
with the File Name with the extension: Scan.jpg
The linked file will open in the default program for the file type.
So if you have all your JPG files open with Photo Viewer, that is the program it will be opened with.
You should also have the option to Insert an Object and link it to a photo, which should also allow you to click and display,
although I have never tried it.
Last edited by xenixman; 01-26-2013 at 03:07 PM.
If you Inserted a Picture using the Illustration section of the Insert tab
then you can also hyperlink the picture by right clicking on the pic and selecting
hyperlink.
Just select the location of the pic and the complete Path name should be in the box labeled Address: at the bottom.
Last edited by xenixman; 01-26-2013 at 05:44 PM.
Another double post.
Last edited by xenixman; 01-26-2013 at 05:43 PM.
I did find a way to do this, in case anyone else could use it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks