Excel: Add a function to retrieve the last Save Date.

[Guest]

Using Office 2000 - It would be very useful to have an Excel function to
retrieve the date (and time) of the last save of a spreadsheet (file) because
much data is meaningless without knowing the currency of the data.
Usage:

Ability to insert last save date (and perhaps time) into a cell for later use
Ability to insert in header or footer so prints can show how current data is
Ability to use function in calculations to answer questions such as: "How old is this data?"

Save Date exists in Word as a field. This function would find widespread use
in Excel, would be easy to implement, and would give greater meaning to data.
It amazes me that you don't have this function already.

 

[Frank Kabel]

Hi
use the following UDF (only on workbook level):

Function DocProps(prop As String)
application.volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

and enter in a cell
=DOCPROPS("last save time")
(format cell as date)