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

[Rick3789]

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

[Ron de Bruin]

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" <[email protected]> wrote in message news:[email protected]...
> Is there a way to show the complete filepath of the current Excel file in a
> toolbar line?

[David Billigmeier]

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?

[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



"David Billigmeier" <[email protected]> wrote in message
news:[email protected]...
> 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?