Can I add an autoupdate file name insert to the document body?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing html documents into Excel adds rows to the body. 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
File path not working correctly 2
Is there an author field in Excel? 4
Transfer text from header/footer into body of document 4
VBA - retrieve data on last create named range from previous inserted named range 0
tab name in the body of a worksheet - &[TAB]? 5
Word How can I stop Word 2010 asking permission to update a document with an included file? 0

Back
Top