Tom, Thanks for this. So, there's nothing I can do about entries in the
General tab, then?

Regards

Pete



"Tom Ogilvy" wrote:

You have to use the correct name.

From the immediate window as a demonstration:

? ActiveWorkbook.BuiltinDocumentProperties.Item("Cre ation Date").Value
3/8/2006 10:16:50 AM

ActiveWorkbook.BuiltinDocumentProperties.Item("Cre ation Date").Value =
"2/25/1987"

? ActiveWorkbook.BuiltinDocumentProperties.Item("Cre ation Date").Value
2/25/1987

This will be reflected under the statistics tab in Properties.

--
Regards,
Tom Ogilvy



"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