Excel Profiler

Set of add-in utilities for Excel to allow the identification of poorly performing spreadsheet forumulas and VBA functions Provides tools to profile and report on worksheet performance, column by column; Add in functions to monitor and report on time spent in any part of your VBA functions; Automatic profiling capabilities that will generate code and insert it in your functions, removing it when the profiling session is over; new vba classes that are open to you for further deep dive. Very simple to use. Provided as a non intrusive excel Add-in.

Whats in the package.

There are various useful modules included such as

- Optimization. Call timeallsheets() to provide a report on how long each column in your workbook takes to execute.

- ProcProfilerWrapper. A set of tools to profile your VBA procedures.

- ApPublic. A set of tools to automatically insert and remove profiling hooks into your procedures. Call autoprofileform() to kick off

- Various utilities and classes to quickly build your own profiling, either one off or permanently.

Who Needs this ?

Anyone who wants to investigate slow worksheet performance, any developer who wants to identify poor VBA performance,

or any developer who wants to build in permament performance profiling or rogue case identification to their application.

Terms of use.

' Not for commercial use except by explicit permission

' full documentation available

' http://sites.mcpher.com/share/