How to show file creation date in a worksheet cell

[Big Sean]

Trying to show the date of creation of the excel 2007 file in a cell - not
date of modification. It's a quotation file, with the date of quotation
coming in automatically as Today(). Trouble is, that changes every time the
file is opened subsequently, so need to have a means of showing the original
creation date of the file

 

[John]

Hi
You can't use Today() or Now() because they're volatile functions, for a
static ( Don`t change ) date function you need to type >Ctrl ;
HTH
John

 

[RonaldoOneNil]

You can do it with a macro like this (format cell A30 in my example as a date)

Sub Display_Creation_Date()
Range("A30").Select
ActiveCell.Value =
Application.ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Sub

 

[Gord Dibben]

You can add this UDF to a general module.

Function CreaDate() As Date
CreaDate = ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Function

Any cell enter =creadate()

Or a macro...........

Sub Display_Creation_Date()
ActiveCell.Value = _
Application.ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Sub


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 06:36:06 -0800, Big Sean <Big