Excel 2003

  • Thread starter Thread starter Lilian
  • Start date Start date
L

Lilian

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.

Lilian
 
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
 
Back
Top