G
Guest
Is there a way to automatically update a cell in Excel 2000 with the date
that the file was last saved?
Thanks!
that the file was last saved?
Thanks!
Bob Phillips said:'-----------------------------------------------------------------
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)
Thanks, Gord!
I got it to work! I wasn't familiar with modules - Thanks again for your
help!
Kevin
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.