Last Update

[Brian Matlack]

Hi!
Is there a formula or function that will show the date MM/DD/YY the workbook was last changed and saved? I'm looking for a way to visually know when the last update took place without going to the properties 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" <Brian.Matlack.289wob_1148409307.1359@excelforum-nospam.com>
wrote in message
news:Brian.Matlack.289wob_1148409307.1359@excelforum-nospam.com...
>
> Hi!
> Is there a formula or function that will show the date MM/DD/YY the
> workbook was last changed and saved? I'm looking for a way to visually
> know when the last update took place without going to the properties
> window.
>
> Any help would be great. Thanks!
>
>
> --
> Brian Matlack
> ------------------------------------------------------------------------
> Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
> View this thread: http://www.excelforum.com/showthread...hreadid=544830
>

[Miguel Zapico]

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" wrote:

>
> Hi!
> Is there a formula or function that will show the date MM/DD/YY the
> workbook was last changed and saved? I'm looking for a way to visually
> know when the last update took place without going to the properties
> window.
>
> Any help would be great. Thanks!
>
>
> --
> Brian Matlack
> ------------------------------------------------------------------------
> Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
> View this thread: http://www.excelforum.com/showthread...hreadid=544830
>
>

[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.