Tracking Instantaneously When the Shared Excel Workbook Is Opened.

[DCE]

In the Excel menu, there are sharing and tracking selections that could be
optionally set on to collect or log and keep within period of time, either on
the screen or a separate sheet of who (id/names of people given access to the
shared workbook, when (date and time changes were made , and what cells
(ranges and changes made) changed in the worksheet within a period of time.

Question: Is there a way of tracking the who and when the file was opened
even if there were no changes made on the worksheet?

 

[Jim Thomlinson]

So you wnat to know who was the last person to open a file and when they did
it even though no changes were made to the file and the file would not have
been saved. Assuming that to be the case you can get the who but not the
when.

Who opened the file is not that easy to get. The problem is that if you open
the file then the last person to open it is you... If however you open the
file using a text editor (which you can download off of the internet) you can
open the file in it's binary form. What you will see will be a whole huge
pile of meaningless characters with odd bits of legible text thrown in. One
of those bits of text will be the last person who opened the file.

 

[Gary''s Student]

Hi Jim:

I found your comments extremely interesting:

How do you determine who openned a workbook if they never save it ??

Suppose we record information when the book is openned and immediately save.
A pre-emptive strike that does not rely on the user saving at all:

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("Audit").Activate
n = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(n, 1) = Now
Cells(n, 2) = Environ("username")
ThisWorkbook.Save
Sheets("Sheet1").Activate
Application.ScreenUpdating = True
End Sub

 

[Jim Thomlinson]

Check out this link...

http://j-walk.com/ss/excel/odd/odd26.htm

 

[Gary''s Student]

Thanks for the info. It's something I never would have expected.