ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I add an autoupdate file name insert to the document body? (https://www.excelbanter.com/excel-discussion-misc-queries/115340-can-i-add-autoupdate-file-name-insert-document-body.html)

Jeni

Can I add an autoupdate file name insert to the document body?
 
I'm trying to add a cover page that automatically includes the file name. In
the header/footer this can be done by typing &[File]. How can I do this in
the body of the document. I don't want to have to change the document every
week as I change the document name.

FloMM2

Can I add an autoupdate file name insert to the document body?
 
Jeni,
You could make a Template of the form you are using and in the cell that
you want the date "=now()". Then when the data is added, "Save As" and change
the file extention to"*.xls" with the dateas the file name.(Example
10_20_06.xls for October 20, 2006)
HTH

"Jeni" wrote:

I'm trying to add a cover page that automatically includes the file name. In
the header/footer this can be done by typing &[File]. How can I do this in
the body of the document. I don't want to have to change the document every
week as I change the document name.



All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com