View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
T Lavedas T Lavedas is offline
external usenet poster
 
Posts: 38
Default 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/