I am trying to create a log for macro use. The macro will be used in a shared workbook environment. I was wondering if it would be possible to record what user ran the macro.
Printable View
I am trying to create a log for macro use. The macro will be used in a shared workbook environment. I was wondering if it would be possible to record what user ran the macro.
Within the macro, open a log text file for appending then append a line with UserName (and ComputerName) and the current time Now() then Close it straight away.
You may need to check the log file if is accessible or not before open it as it may happen 2 or more users try to open the log file at the same time.
If the log file is busy then need to wait until other user close it before open it for appending.
Other solution is to create an Access-97 mdb file with a log table then within the macro use DAO to Add a new record with required information. The user does not need to have MS-Access to do that.