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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill PrewCommented:
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 LissOlder than dirtCommented:
Another way is lock the workbook and/or the code and wait for them to come to you:)
1
aikimarkCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.