I have an Excel file on my work network. Everyone has a User ID and can open the file as either read-write or read-only. I need to track anytime someone accesses the file (whether they save or not)- just their user ID and the date/time. I am VERY new to this so I have basically just copy/pasted macros to get the information I need. However, I can only save the file in my "Log" worksheet when the user saves the file. If they open it as Read Only or choose not to save upon closing, the "Log" is not updated. How do I update the "Log" every time and save it regardless if the file is saved upon closing? I can make another file, but I have NO idea how to get the information into this other file. Any help would be appreciated! Thanks!
Private Sub Workbook_Open()
Worksheets("Log").Range("A65536").End(xlUp).Offset(1, 0).Value _
= Format(Now(), "mm-dd-yy HH:MM AMPM")
Worksheets("Log").Range("B65536").End(xlUp).Offset(1, 0).Value _
= Environ("UserName")
End Sub
Private Sub Workbook_Open()
Worksheets("Log").Range("A65536").End(xlUp).Offset(1, 0).Value _
= Format(Now(), "mm-dd-yy HH:MM AMPM")
Worksheets("Log").Range("B65536").End(xlUp).Offset(1, 0).Value _
= Environ("UserName")
End Sub