Not sure about Excell but it is very simple in Word. Go to Insert |
Autotext | Header/Footer and select either Filename or File Name and Path.
You can insert the name anywhere, not jus tin a header/footer. Or you can
insert a Field Code wherever you want. Go to Insert | Field; scroll down to
FileName and select it. If you want the path check the box Add Path to
FileName. Note that this works best if you have already named the document.
Otherwise, it will be named Document 1, 2, 3 . . ., which is probably not
what you want. But whichever way you insert it, you will end up with a
field that can be easily updated (Right click on the field/pathname and
select Update Field).
For more information about fields see:
http://addbalance.com/usersguide/fields.htm
http://addbalance.com/word/wordwebresources.htm#Fields
"strawbs85" wrote in message
...
I'd like to add a footer to my documents showing where the document is
saved.
eg: c:/documents/work/profitloss
How can I make this happen automatically on all my word and excel
documents?