| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show the current Excel filepath in the toolbar line?
Is there a way to show the complete filepath of the current Excel file in a
toolbar line? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show the current Excel filepath in the toolbar line?
You can display it in a cell by typing the following (verbatim)
=CELL("filename") -- Regards, Dave "Rick3789" wrote: Is there a way to show the complete filepath of the current Excel file in a toolbar line? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show the current Excel filepath in the toolbar line?
Hi Rick
Only with code you can do it as far as I know ActiveWindow.Caption = ActiveWorkbook.FullName -- Regards Ron de Bruin http://www.rondebruin.nl "Rick3789" wrote in message ... Is there a way to show the complete filepath of the current Excel file in a toolbar line? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show the current Excel filepath in the toolbar line?
=CELL("filename")
You should add a cell reference to this function. =CELL("filename",A1) Otherwise, the result will be the active workbook when a calculation is made, which may not be the same workbook that contains the formula. Including a cell reference -- any cell will do -- will prevent this error. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "David Billigmeier" wrote in message ... You can display it in a cell by typing the following (verbatim) =CELL("filename") -- Regards, Dave "Rick3789" wrote: Is there a way to show the complete filepath of the current Excel file in a toolbar line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
| Line Chart - show percent and value? | Charts and Charting in Excel | |||
| how to change line spacing for text box in excel chart | Charts and Charting in Excel | |||
| Forcing Excel to Load Below Office Toolbar | Excel Discussion (Misc queries) | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
Linear Mode
