Using BuiltinDocumentProperties to insert LastSavedTime into a cell

Question

In order to display the last time a workbook has been updated, i have been trying unsuccessfully to use the BuiltinDocumentProperties VBA function, but i keep getting an error. I would like the cell (C12 in my example below) to finally display the last date and time someone saved the workbook.

Here's the code i've been trying to use:

Sub Macro2()

'

' Macro2 Macro

' lastsavetime

'

Worksheets(1).Activate

Cells(C, 12).Value = ActiveWorkbook.BuiltinDocumentProperties(12)

'

End Sub

Can anybody help me with this?

Answer 1

Instead of Cells(C, 12), use Range("C12") or Cells(12, "C")

Don't forget to format cell C12 as a data or as a date+time.