Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
menu / toobar item for open file by name
is there a way to open a specific file, as a button on a toolbar? thanks
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
menu / toobar item for open file by name
You may use the HYPERLINK formula in a cell, something like:
=HYPERLINK("file://C:\Test\test.xls") Change the "C:\Test\test.xls" part to the file you want to open, and the link will launch the file you select. Hope this helps, Miguel. "nastech" wrote: is there a way to open a specific file, as a button on a toolbar? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
menu / toobar item for open file by name
thanks, that worked; from that I also found using hyperlink in a toolbar
worked as well. (for others: right-click any toolbar, custom, insert, hyper-link, drag-drop it to a tool-bar, click: asign link, drill down to your file name). "Miguel Zapico" wrote: You may use the HYPERLINK formula in a cell, something like: =HYPERLINK("file://C:\Test\test.xls") Change the "C:\Test\test.xls" part to the file you want to open, and the link will launch the file you select. Hope this helps, Miguel. "nastech" wrote: is there a way to open a specific file, as a button on a toolbar? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
How can I add "File" to my menu? | Excel Discussion (Misc queries) | |||
XML Source Menu Item disabled?? File version?? | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |