Category Archives: Software Testing

Free Add-In to profile VBA speed and coverage

I’m making available a beta version of my VBA performance profiler for people to try it out and let me know what they think. I’m interested in seeing what kinds of VBA code trip it up and produce syntax errors. … Continue reading

Posted in Excel/VBA, Software Testing | 2 Comments

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

Excel & Genes: mutation and curation

On 23 Aug a paper by three Australian authors gained much publicity about how Excel interprets data entry and how the users don’t check their data. http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 Gene name errors are widespread in the scientific literature. By Mark Ziemann, Yotam … Continue reading

Posted in Excel/VBA, Research, Risk, Software Testing | 1 Comment

Eusprig 2016 July 7, London

The European Spreadsheet Risks Interest Group 17th Annual Conference (EuSpRIG 2016) will be held at the Institute of Chartered Accountants in England and Wales (ICAEW), Moorgate, London, on the 7th July 2016. http://www.eusprig.org/annual-conference.htm The programme is now available. Register now to … Continue reading

Posted in Excel/VBA, Research, Risk, Software Testing | 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

SoftTest Ireland Conference 2015 – Future Proof your Software Testing

SoftTest Ireland in association with the ISA Software Skillnet are hosting a one-day national conference for software test professionals. Date: Wednesday 23rd September 2015 9am – 5.30pm Venue: Clyde Court Hotel, Ballsbridge, Dublin 4 Cost: €100.00 per delegate Book here: … Continue reading

Posted in Software Testing | Tagged , | Leave a comment