In an attempt to track users use of a document from ACCESS POINT, I have created a small macro that writes to a .csv file in a common area. The data collected is Date, Time, UsersName, Sheet accessed, Object Accessed on Sheet.
For that I have set the Document setting to include a trigger OnAnySelect to fire the macro which happens when any selection in a table/chart/listbox happens. I have also added a call for the macro when a sheet is selected.
The issue I have is that everything works fine when I open and navigate through the document but none is happening when other users do. I have set the Requested Module Security to System Access and the Current Local Security to Allow System Access and our IT department had set permissions to allow everyone to write to the folder where the .cvs file resides.
Does anyone have an insight of why the macro does not write to the file when others use the document?
(The tracking is temporary just until I get an understanding of the usage because writing to the cvs file slows down the actions in the document)