Excel 2007: is it possible to get in the title bar the complete file name & path?

[Daniel]

Hi everybody,

not a major issue but...

Is it possible to display the complete file name & path in the title bar of
Excel 2007, by means of some kind of AutoOpen macro, for example?

If so, what code should I write in the macro?

Many thanks in advance for your kind help.
with Brgds,
Daniel
Office 2007 newbie

 

[Daniel.C]

Hi.
Use :
Application.Caption = ActiveWorkbook.FullName
Regards.
Daniel

 

[Roger Govier]

Hi Daniel

you can add it to the QAT.
Round Office button>Excel Options>Customise>All commands>Document Location

 

[Daniel]

Thank you very much, Roger. I do appreciate.
brgds,
Daniel

 

[Daniel]

Super. Thank you very much indeed, Daniel.C

With my brgds,
Daniel

 

[Daniel]

Super. Thank you very much indeed, Daniel.C

With my brgds,
Daniel