Last Update

[Brian Matlack]

Hi!
Is there a formula or function that will show the date MM/DD/YY th
workbook was last changed and saved? I'm looking for a way to visuall
know when the last update took place without going to the propertie
window.

Any help would be great. Thanks

 

[Bob Phillips]

'-----------------------------------------------------------------
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 such as
=DocProps ("last author")
or
=DocProps ("last save time")


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Brian Matlack" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

You can use a custom function like this:
Function LastSaved()
LastSaved = Format(ActiveWorkbook.BuiltinDocumentProperties("Last Save
Time").Value, "mm/dd/yyyy")
End Function

Hope this helps,
Miguel.

 

[Brian Matlack]

Great Help to Both Bob and Miguel! Thanks Alot!!

 

[cpono]

I need to do exactly what that guy is asking. However, I do not know
where to paste that function. I want it to show on a cell.