File Creation Date

  • Thread starter Thread starter John Wagenvoort
  • Start date Start date
J

John Wagenvoort

Hi,

Just wondering if anyone knows how to display the file creation date in a
cell in a worksheet.

Thanks

John
 
I know there is a way to use field codes in WORD to display document
properties. There may be something analogous in Excel.
 
Try a UDF like

Function DocProps(prop As String)

On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
Exit Function

err_value:
DocProps = CVErr(xlErrValue)
End Function

Called with

=DocProps("Creation date")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
John,

You can use a UDF. Copy the code below into a standard usermodule in your workbook, and use it like

=CreationDate()

HTH,
Bernie
MS Excel MVP

Function CreationDate()
CreationDate = Application.Caller.Parent.Parent. _
BuiltinDocumentProperties("Creation Date").Value
End Function
 
Back
Top