How do I show the current Excel filepath in the toolbar line?

R

Rick3789

Is there a way to show the complete filepath of the current Excel file in a
toolbar line?
 
D

David Billigmeier

You can display it in a cell by typing the following (verbatim)

=CELL("filename")
 
R

Ron de Bruin

Hi Rick

Only with code you can do it as far as I know

ActiveWindow.Caption = ActiveWorkbook.FullName
 
C

Chip Pearson

=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
 
Top