| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i insert an outlook msg file object in excel | Excel Worksheet Functions | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| Help, insert a word document contents into excel tab? | Excel Discussion (Misc queries) | |||
| insert multiple page Word document into Excel | Excel Discussion (Misc queries) | |||
| i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) | |||
Linear Mode
