Right-click cell and open filename in explorer program
 

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

Right-click cell and open filename in explorer program
 

On May 12, 10:48 am, "
wrote:
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/