Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you color an excel filename in windows explorer | Excel Discussion (Misc queries) | |||
Open File based on filename in cell | Excel Programming | |||
Opening Program Thru Explorer | Excel Discussion (Misc queries) | |||
Double Click to open external program | Excel Programming | |||
Need to write a program to open a filename... | Excel Programming |