Hyperlinking to a graphic

G

G. Smith

How can I make Excel 2002 open a hyperlinked image with a specific graphics program as opposed to the Microsoft Imaging program

Thanx in advance for any tips!!
 
F

Frank Kabel

Hi
the chosen graphic program depends on the Windows settings for this
specific extension. That is if you have assigned the extension*.jpg to
MS Image then this program is opened if you click on the hyperlink.

--
Regards
Frank Kabel
Frankfurt, Germany

G. Smith said:
How can I make Excel 2002 open a hyperlinked image with a specific
Click to expand...
graphics program as opposed to the Microsoft Imaging program?
 
G

G. Smith

I guess I should've been a little more specific w/ my first ask. I'm creating a "data-base" for multiple users, some more experienced than others, and I'd like to make sure that the graphic hyperlinks will open with a program that all users are familiar with using. I know that I can set file assignments within Windows, but need to make sure that the same program opens the link on all computers that open my Excel file

I'm kind of a rookie with Excel and don't know if this is even possible?

Thanx again
G
 
F

Frank Kabel

Hi
AFAIK this is not possible with hyperlinks only referencing the
filename. You may try to create a hyperlink like the following:
c:\programs\your_program_path+name graphic_file_name

Depends if your graphic program allows a filename as parameter

--
Regards
Frank Kabel
Frankfurt, Germany

G. Smith said:
I guess I should've been a little more specific w/ my first ask. I'm
Click to expand...
creating a "data-base" for multiple users, some more experienced than
others, and I'd like to make sure that the graphic hyperlinks will open
with a program that all users are familiar with using. I know that I
can set file assignments within Windows, but need to make sure that the
same program opens the link on all computers that open my Excel file.
 
J

Jon Peltier

In cast the hyperlink doesn't work, try the Shell command.

Shell "ProgramFullName FileFullName", vbNormalFocus

or in the example I used:

Shell "C:\Program Files\Common Files\Microsoft
Shared\PhotoEd\PhotoEd.exe C:\TEMP\Chart.gif", vbNormalFocus

The command is all on a single line.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top