How do I show the last saved date in an Excel worksheet?
I have an Excel worksheet that is updated on a regular basis. I'd like to
include a cell that shows the last date saved so that its easy to tell how current the worksheet is. Any advice? Thanks! |
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) -- Regards Frank Kabel Frankfurt, Germany "mgriffie" schrieb im Newsbeitrag ... I have an Excel worksheet that is updated on a regular basis. I'd like to include a cell that shows the last date saved so that its easy to tell how current the worksheet is. Any advice? Thanks! |
All times are GMT +1. The time now is 07:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com