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

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

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?"
Click to expand...

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.
 
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)
 
Back
Top