ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hyperlinking to a graphic (https://www.excelbanter.com/excel-programming/298340-hyperlinking-graphic.html)

G. Smith

Hyperlinking to a graphic
 
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

Hyperlinking to a graphic
 
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" schrieb im Newsbeitrag
...
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!!



G. Smith

Hyperlinking to a graphic
 
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

Hyperlinking to a graphic
 
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" schrieb im Newsbeitrag
...
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



Jon Peltier[_7_]

Hyperlinking to a graphic
 
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/
_______

Frank Kabel wrote:

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" schrieb im Newsbeitrag
...

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






All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com