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

'-----------------------------------------------------------------
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"
wrote in message
news:Brian.Matlack.289wob_1148409307.1359@excelfor um-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

You can use a custom function like this:
Function LastSaved()
LastSaved = Format(ActiveWorkbook.BuiltinDocumentProperties("L ast 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

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


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

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.


--
cpono
------------------------------------------------------------------------
cpono's Profile: http://www.excelforum.com/member.php...o&userid=34775
View this thread: http://www.excelforum.com/showthread...hreadid=544830