Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Usage statistics in VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba courses london - Usage statistics in VBA
Resolved · Low Priority · Version Standard
Reply Thu 15 Mar 2007, 15:33Delegate Nick said...
Nick has attended:
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
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
For upcoming training course dates see: Pricing & availability
RE: Usage statistics in VBA
Hi Nick
This is an area we do have experience in working with. It is more consultancy than training whereby we would ask you to outline your specification for us to review, we can then relate the scope of work required and cost.
It may help in the first instance to attend our 2 day Excel VBA course which may give you enough insight to get the ball rolling on this project and then contact us only if you can't progress any further.
http://www.microsofttraining.net/excel-course-in-london-2003-vba.php
If you would like to discuss this further, feel free to contact me jacob
Rgds
Jacob
|