Hello
I would like to keep an activity log of who opens my workbook and at what time.
Is it possible to write to a file (CSV preferably) the following information:
DATE, TIME, Windows Logon ID, Computer ID
Any help is greatly appreciated!
Hello
I would like to keep an activity log of who opens my workbook and at what time.
Is it possible to write to a file (CSV preferably) the following information:
DATE, TIME, Windows Logon ID, Computer ID
Any help is greatly appreciated!
If they enable macros then yes.
You would need to place a call to the logging routine in the Workbook_Open event.
The logging routine can use simple file I/O to add a record to the file
Thisworkbook code
Module code![]()
Please Login or Register to view this content.
You need to search the forum for details on getting the logon and computer id.![]()
Please Login or Register to view this content.
There are currently 2 users browsing this thread. (0 members and 2 guests)
Bookmarks