How do I open external jpeg files from within an Excel spreadsheet, and have the jpeg come up in Windows Picture Viewer, not Internet Explorer?
Posted on 2013-01-23
I am trying to open external jpeg files from within an Excel spreadsheet. The jpeg files are in a column, as a list. The actual jpegs are on a server, and the path is part of the list/name of the jpeg. I created a button for a user to click, with a hyperlink, and a vlookup to the list. I have a pulldown menu tied to the list too. All this works fine, but when the button is clicked, MS Internet Explorer is invoked, and the jpeg comes up in Explorer.
Here's the issue: when I click on a jpeg in MS WINDOWS EXPLORER (not MS Internet Explorer, but rather the MS program that we all use to look at files and folders from the MS Start Button on the bottom Windows tool bar, WINDOWS EXPLORER), the jpeg comes up in the WINDOWS PHOTO VIEWER, which is where I need the jpeg to come up in -- not in MS Internet Explorer! The reason I need the jpegs to come up in Windows Photo Viewer is because the user needs to see the entire series of jpegs, one after the other, and by them just pressing the arrow key in Windows Photo Viewer, they can view one after another, just by invoking the first one in the series from Excel. In IE, only the one jpeg comes up there, and there is no way to see the others on the server, just the one jpeg invoked from Excel.
So I need the selected jpeg from the list in Excel to come up in Windows Picture Viewer (so the user can see the entire series of jpegs on the server in that folder), I don't want the jpeg to invoke and come up in Internet Explorer, which is what "=Hyperlink(file)" is currently doing, in other words, "=hyperlink"(file) brings only the one jpeg listed in Excel up in IE. Not useful in this situation.
What can I do to properly solve this interesting problem? Is there another command that can be used instead of "=Hyperlink" ? I cannot edit HKEYS as I do not have admininstrator rights. I am also trying to stay away from using visual basic.