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 2000, 2002/XP, 2003, 2007, 2010 and 2013. 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.
The VBA Code Profiler (VBACP) system requires any of the Microsoft® VBA systems from Microsoft® Office 2000, 2002/XP, 2003, 2007, 2010 and 2013 suites of software to be installed and required to be profiled.
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 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:
show me less content in the footer
show me more content in the footer