Yeah, you're right. My mistake.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Peter Rooney" wrote in
message
...
Chip, it changes the value on the "Statistics" tab, but the
value in the
"General" tab remains unchanged.
Cheers
Pete


"Chip Pearson" wrote:

Try

ThisWorkbook.BuiltinDocumentProperties("Creation Date").Value
=
Now



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Peter Rooney" wrote
in
message
...
Good afternoon, all.

Is there a reason why the following doesn't work?

Sub ChangeCreationDate()
ActiveWorkbook.BuiltinDocumentProperties.Item("Cre ation
Date:").Value =
"06/03/07"
End Sub

Does the date have to be in a particular format, or it is
simply because
there are some properties you just can't change?

Thanks in advance

Pete