ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   menu / toobar item for open file by name (https://www.excelbanter.com/excel-discussion-misc-queries/99192-menu-toobar-item-open-file-name.html)

nastech

menu / toobar item for open file by name
 
is there a way to open a specific file, as a button on a toolbar? thanks

Miguel Zapico

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


nastech

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



All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com