Right-click cell and open filename in explorer program

[caveatRob]

Hi all,

I'd like to be able to right-click a cell in Excel and open the
filename in the cell in the associated app. What's the best way to:

* set up a custom context menu item for this?
* actually open the file?

Rob

 

[T Lavedas]

Hi all,

I'd like to be able to right-click a cell in Excel and open the
filename in the cell in the associated app. What's the best way to:

* set up a custom context menu item for this?
* actually open the file?

Rob

Store the name as a hyperlink? There is also a Hyperlink function
that will convert the filename into a hyperlink. The difference is
that the link is followed the hyperlink is left-clicked. However, if
you add a column of =HYPERLINK() formulas next to the column of file
names and code a literal friendly name into the formula, like OPEN,
the named file is easily accessed by clicking the cell next to the
file's name. The hyperlink opens the file in its associated
application.

Tom Lavedas
===========
http://members.cox.net/tglbatch/wsh/