Excel 2003

[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

 

[Bob I]

Wouldn't the file modified date be what you want?

 

[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

 

[Etz99]

Lillian,

try the formula = NOW() this should update your date field