Category Archives: Uncategorized
Tracing & Profiling VBA speed with TraceSpy
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
Rubberduck VBA addin
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
Conditional compilation VBA Excel Mac/Win/32/64…
To make my addin handle all the combinations of Excel 2007 onwards on Mac and Windows, 32-bit and 64-bit, I ended up with this conditional compilation block. The example I use is GetTickCount() but the principle applies to other declarations. Microsoft … Continue reading
Modeless Userform not terminating
One way to display status messages as a long procedure runs is to show a modeless userform and update it with text or a progress bar showing percentage completed. I was having a problem with Excel crashing, particularly Excel 2013, … Continue reading
VBA Code Tracer / Profiler
A VBA module to insert code to trace the execution of VBA code. Continue reading
Excel Options for updating external links
There are many options in Excel that control this depending on the kind of link it is. I’ll cover the usual external links in formulas first, then finish up with the other kinds. An external link formula shows the full … Continue reading
XLTest 1.55 released
I have updated my spreadsheet auditing addin. Changes in version 1.55 1. On startup, it checks and fixes autonumber seed problems in database 2. Processing limit of 1 million cells made an option 3. ExportActiveProject procedure runnable by VBA automation … Continue reading
