nike_golf
asked on
Last user and file open date?
Is it possible to get the last user that opened a workbook and when that date was not using a macro in the actual workbook? However it would be OK to use another workbook and VBA to get the stats.
Can this be done via the API to get the file information?
Looking for some ideas and thoughts but they can't be directed at using the actual workbook and VBA to achieve this.
NG,
Can this be done via the API to get the file information?
Looking for some ideas and thoughts but they can't be directed at using the actual workbook and VBA to achieve this.
NG,
You can use Windows security to audit file access. Unless the user changed and saved the workbook, the information will not be stored as a file property as far as I know.
ASKER
How would you profess that would work?
The file that is to be accessed is on a network share so its not on a central computer. I think the information would have to be somehow tied directly to the file.
Thoughts?
NG,
The file that is to be accessed is on a network share so its not on a central computer. I think the information would have to be somehow tied directly to the file.
Thoughts?
NG,
The server can be set up to audit file access - I don't know the exact details offhand as it's a Windows thing not Excel and it's been many years since I was a network admin.
ASKER
I am looking for a more user level approach.
NG,
NG,
The only alternative I can think of would be an addin on each machine that monitored each file opened checking for a particular name and then logged the access to it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Self Answered
ASKER
Private Sub Workbook_Open()
' Stores who and when on Sheet1, column A
Sheets("Sheet1").Select
If Range("A65536").End(xlUp).
Range("A65536").End(xlUp).
Exit Sub
End If
Range("A65536").End(xlUp).
End Sub