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

C

CRayF

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

Rich Hartmann

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

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
 
Top