Druv M
asked on
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).Ca ption = ThisWorkbook.Windows(1).Ca ption & _
" Last Updated By: " & _
ThisWorkbook.BuiltinDocume ntProperti es("Last Author") & _
" on " & _
ThisWorkbook.BuiltinDocume ntProperti es("Last Save Time")
End Sub
Option Explicit
Private Sub Workbook_Open()
ThisWorkbook.Windows(1).Ca
" Last Updated By: " & _
ThisWorkbook.BuiltinDocume
" on " & _
ThisWorkbook.BuiltinDocume
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.