date

[Guest]

I need that on one of my cell in the spreedsheet ,will show the creation date
of the file and i am not talking about a function that will show the date of
when i opened the file.

Does someone know?

 

[dominicb]

Good evening Shira

Is a macro acceptable. This will place the creation date in cell A1.

Sub Test()
Range("A1").Value = ActiveWorkbook.BuiltinDocumentProperties("Creatio
Date").Value
End Sub

HTH

Dominic

 

[Guest]

Thanks!!