Monthly Archives: Feb 2017

Tracing & Profiling VBA speed with TraceSpy

Posted on Feb 21, 2017 by Patrick O'Beirne, Excel/VBA developer

I’m interested in measuring VBA performance. I add tracing calls to the routines so I get the time on entrance and exit. I also optionally add a call to trace every line executed, which I use when I get unexpected … Continue reading →

Posted in Software Testing, Uncategorized | Leave a comment

Rubberduck VBA addin

Posted on Feb 17, 2017 by Patrick O'Beirne, Excel/VBA developer

The Rubberduck VBA (@rubberduckvba) open source project has been going for a couple of years, and when I was reminded of it recently I decided to give it a try. It’s definitely a help in VBA development and I’ll go on … Continue reading →

Posted in Excel/VBA, Open Source, Software Testing, Uncategorized | Leave a comment