Hello all,

I have an Excel file (userfile.xls) that users make a copy and use it to
make analysis. I want to track who uses it and the date that uses the file.

I need some help with the code, and the code will be part of Workbook_Open
code and will execute when the userfile.xls file is opened.

I am looking for the code that will put the username in Cell A1 of Sheet1 in
the userfile.xls file. Then it will populate the username and the date (e.g.
now()) into an external Excel tracking file (trackfile.xls) under columns A
and B for username and date, respectively. If Cell A1 of Sheet1 in the
userfile.xls is already populated with a username, the code will not execute
(populate Cell A1 of Sheet1 in the userfile.xls nor the trackfile.xls).
Since there will be more than one user, I would like the code to populate the
username and date in the trackfile.xls on the next (empty) row of previously
recorded username and date, instead of overwriting the previous ones.

Since the trackfile.xls file will be on the network and the userfile.xls can
be used without being on the network, I would like the code not to execute.
The code will only execute when the userfile.xls file is used while
connecting to the network.

Lastly I would like the code to execute without being realized by the users
that the usage is being tracked.

Please help. Thanks.