Display "Last updated date" for the Workbook (without using a macr

[Guest]

Is there a way to diasplay in a cell the "Last updated date" the workbook was
saved without using a marco?
thanks in advance,

 

[Bob Phillips]

don't think you can.

 

[Rich Hartmann]

Is there a macro that can display the last updated date in a spreadsheet?
Rich

 

[Gord Dibben]

Sub lastsavetime()
With ActiveSheet
.Range("A1").Value = "Last Saved "
.Range("B1").Value = Format(ThisWorkbook.BuiltinDocumentProperties _
("Last Save Time"), _
Format("yyyy-mmm-dd hh:mm:ss"))
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 28 Oct 2009 11:37:01 -0700, Rich Hartmann <Rich