VBA Code Profiler
Overview
The VBA Code Profiler System (VBACP) provides a system to profile Microsoft® VBA based applications. This will allow analysis of your code for performance and path tracking throughout your VBA project. The VBACP system will operate on any Microsoft® VBA based application from Office 97, 2000, 2002/XP, and 2003. The profiler itself is required to be installed into your code and then you are required to instrument the code requiring profiling.
Systems currently supported are Microsoft® Excel®, Word®, and Access®. If you require additional modules, please contact us.
The diagram below, illustrates the resultant code after the code has been instrumented and the profile initialisation and report commands added.
System Pre-requisites
The VBA Code Profiler (VBACP) system requires any of the Microsoft® VBA systems from Microsoft® Office 97, 2000, 2002/XP, and 2003 suites of software to be installed and required to be profiled.
Instrumenting your Code
Instrumenting, and finally cleaning your code, is as simple as inserting the profiler form into your code and running it.
There is also a batch utility to allow you to instrument/clean multiple Word and Excel projects in a single pass. Below is a sample screenshot of the batch installer:
The Profile Report
The output is in the form of a text based report to allow importing into Excel and other tools for graphing purposes. The report produced by the VBACP system is illustrated below, detailing the results:
Adobe Acrobat (PDF) files require Adobe Acrobat Reader. Acrobat Reader can be obtained from Adobe. 
© Copyright 1999-2004 by Bandwood Pty Ltd. All rights reserved. This document contains information proprietary to Bandwood Pty Ltd. No part of this document may be reproduced in any form by any means without permission in writing from Bandwood Pty Ltd (
).
Microsoft® Office 97/2000/XP/2003, Excel®, Word®, and Access® are trademarks of Microsoft Corporation, USA
