Something like

range("a1").value = now

"Andy Ralph" wrote:

Hi, I am trying to set up an Excel 2003 template for other users to use to
create new spreadsheets and return them to me.
I want to set a cell to show the Creation Date of the new spreadsheet,
created from the template.
If I set the cell in the template to
ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
when I create a new file from the template, the cell still shows the date
the template was created, not the date the new spreadsheet was created.
Any ideas please?