Our Products

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 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.

 

VBA Code Profiler 1

 

System Pre-requisites

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 your Code

Instrumenting, and finally cleaning your code, is as simple as inserting the profiler form into your code and running it.

 

VBA Code Profiler

 

 

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:

 

VBA Code Profiler

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:

 

VBA Code Profiler

Buy Now

Download