Hyperlinking to a graphic

[Guest]

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!!

 

[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

How can I make Excel 2002 open a hyperlinked image with a specific

graphics program as opposed to the Microsoft Imaging program?

 

[Guest]

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

 

[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

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.

 

[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/
_______