date

S

SHIRA

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?
 
D

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
 
Top