MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating a log file to find out who is using the file


Posted by Greg G on August 10, 2001 6:01 AM

I would like to create a log file that shows who is using a shared excel workbook. Any ideas? Thanks in advance.


Posted by Damon Ostrander on August 11, 2001 9:16 PM

Hi Greg,

I suggest you put some code in the Workbook_Open event to save the Excel application's registered user's name (Application.UserName) to a hidden/protected worksheet or to a server file that all users (including you) have access to. This will work so long as the application is registered in the user's name, not the company name. In the latter case, you can pop up a UserForm requesting that the user enter his/her own name, and store this as the Application.UserName.

Happy computing.

Damon