vba courses london - Usage statistics in VBA

Could you tell me how to create an excel document that monitors usage of many others using visual basic?

I currently produce excel reports for my company but need to somehow monitor how many times they are accessed and, if possible, when and by whom.

All these excel files are situated on a server that our company uses and all users systems are connected to this. We use office 2003 and Outlook as the emailing system.

My guessing is that the programming would have to intiate the usage file, ammend it, and then close it each time a report is opened.

Could you help?

Many thanks

Nick Peutherer