How to determine who last modified an Excel file

Guys, I am trying to find out a way to identify who modifies my excel file in office? I am using the code mentioned below but it's only giving me "Administrator" as the name who updated excel file instead of real person name.

Option Explicit

Private Sub Workbook_Open()
 
ThisWorkbook.Windows(1).Caption = ThisWorkbook.Windows(1).Caption & _
"   Last Updated By: " & _
ThisWorkbook.BuiltinDocumentProperties("Last Author") & _
" on " & _
ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
 
End Sub
Druv MAsked:
Who is Participating?
 
Tom CieslikConnect With a Mentor IT EngineerCommented:
Right click on xlsx document and go to properties then Details
It should tell you who saved document for the last time.

For test only first screenshot is from Old document, then I've opened it and modified it and save,,, look for differences

Capture.JPG
After Edit

Capture1.JPG
0
 
Bill PrewConnect With a Mentor Commented:
Your VBA code looks okay.  Are you sure someone / something isn't updating the Excel file from the Administrator account?

Have you looked at just "Author" as well, what does that show?


»bp
0
 
Martin LissConnect With a Mentor Older than dirtCommented:
Another way is lock the workbook and/or the code and wait for them to come to you:)
1
 
aikimarkConnect With a Mentor Commented:
In the open event, you can get the current user name from the environment variable or the GetUser API.  If it is "Admin", your code can prevent a normal open.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.