Hello everyone, hope someone knows how I can progress with this:
I would like a piece of code that would save some information whenever a file in a specific directory was opened.
The directory is: "s:\referencedocuments\files\"

I would like a log file to save the following details:
the name of the file (could be any of 50+ excel spreadsheets,
when the file was opened
the name of the user who opened the file (based on NT login)
when the file was closed
time in minutes when the file was open.


Is this at all possible. I have used something similar using Workbook_Open and Workbook_BeforeClose for getting this information for individual files but I would really like something that could be run for any file in the directory.

Thanks for any help
Amy xx