Display date modified

[Guest]

Is there a formula that displays the date the file was last modified. I
would like a formula similar to the =now() function, except it displays the
date the file was last modified (as shown in properties).
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

(replace somewhere in email address with gmail if mailing direct)

 

[Bill Ridgeway]

In the cell you want the message displayed enter the formula -
=TODAY()
Format that cell as custom and, in 'type', enter
"The message you want displayed" dd/mm/yyyy

You will also need to make sure the spreadsheet is updated manually. To do
this-
Click on <Tools><Options><Calculations><Manual>

Regards.

Bill Ridgeway
Computer Solutions