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

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

don't think you can.

--
HTH

Bob Phillips

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

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

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

"Bob Phillips" wrote:

don't think you can.

--
HTH

Bob Phillips

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

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

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
wrote:

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

"Bob Phillips" wrote:

don't think you can.

--
HTH

Bob Phillips

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