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

Posted in Software Testing, Uncategorized | Leave a comment

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

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

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

Posted in Excel/VBA, Uncategorized | Tagged , , | 2 Comments

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

Posted in Excel/VBA, Uncategorized | Tagged , | Leave a comment

VBA Code Tracer / Profiler

A VBA module to insert code to trace the execution of VBA code. Continue reading

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

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

Posted in Excel/VBA, Uncategorized | Tagged | 5 Comments

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

Posted in Uncategorized | Tagged | Leave a comment