Last Modified by...
thanks, that helped to log the last user.
I saw, that I can use this script also to log other data.
Very helpfull, thanks a lot!
"Bob Phillips" wrote:
'-----------------------------------------------------------------
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)
"WJvanRooijen" wrote in message
...
how do I find out who last modified the file that I want to check?
Eg.:
I open an Excel-File and want to know, who did the last modification and
saved it and when did he/she did that.
I want to run a small macro to display the Username in a Textbox on the
screen.
thanks for your help!
Wim-Jan
|