Automatically Create a Footer

[punkin0601]

Is there a way for Excel to automatically put the path and file name as a footer every time you create a new file?

 

[Erdinç E. Karaçam]

... create a new file?...

How Excel know that where is the full path of an unsaved file?

So, if it possible, someone tell us how to determine the path of an unsaved file?.

I think that your question is invalid.

 

[punkin0601]

I want it to put "&[PATH]&[FILE]" in the header or footer of every document I create without having to go into the page setup every time.