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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
Is there a macro that can display the last updated date in a spreadsheet?
Rich
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Current Date & Time in a cell: Everytime I open the workbo 4
Display date when worksheet last updated? 1
Display a update date on a sheet for a shared excel workbook 1
Updating Workbooks from multiple links Workbooks 1
Referencing another workbook using a variable for the sheet? 20
Can't unshare workbook 7
Any formula to insert last document saved date ? 1
update workbook links over network 1

Back
Top