Excel 2003



Can anyone help me please! I am faced with the dilemma of how to
automatically refresh the date as the Sales Engineers update their reports. I
entered the formula =today() but it does not reflect the date when their
report was really updated? I am to eliminate cheating on their reporting.

I truly appreciate any answer to my query.


Gord Dibben

Using VBA you can grab the "last save time" from document properties.

Where would you like this placed?

The code below stored in Thisworkbook module will give you last save time in
activesheet A1...............edit to suit or post back for more help.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
ActiveSheet.Range("A1") = "Last Saved : " & _
Format(ThisWorkbook.BuiltinDocumentProperties _
("Last Save Time"), _
"yyyy-mmm-dd hh:mm:ss")
End Sub

Gord Dibben MS Excel MVP

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