"Last Saved" date in Excel 2000
Hi Bob........this looks cool, and something I could use, but I can't seem to
make it work in XL97. Is there some adjustment that needs to be made to
accomodate 97?
Tks,
Vaya con Dios,
Chuck, CABGx3
"Bob Phillips" wrote:
'-----------------------------------------------------------------
Function DocProps(prop As String)
'-----------------------------------------------------------------
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentĀ*Properties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function
and enter in a cell such as
=DocProps ("last author")
or
=DocProps ("last save time")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Rachael" wrote in message
...
Is there a way to automatically update a cell in Excel 2000 with the date
that the file was last saved?
Thanks!
|