Last Saved date

  • Thread starter Thread starter Yppes
  • Start date Start date
Y

Yppes

Hi

Please help a newbie.

Kindly, someone show me how I can make a content of a cell
to show "the last time the spread sheet was saved". This
cell in question is part of the same spread sheet.

The save function can be (both) when the file is still open
or right before it's closed. The content of a cell should
reflect (in date format) when the sheet is saved.

Thanks in advance.

Yepps
 
Hi
use the following UDF:

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