Hi all there,

I am pretty new at VBA. I do not know how to do something that should
be easy, IMHO.

I use Office 2003 with WinXP SP2. I open an excel template in VBA.

but I also want Excel to show the proposed filename in the titlebar not
as "Book1" but as "C:\MyPath\Myfile.xls".

In other words, I want to be able to choose the default path and the
filename for the opened and active excel file (what you see in the
titlebar).

Can anyone help me with this?

Thanks.
Fabian