Author Archives: Patrick O'Beirne, spreadsheet auditor

About Patrick O'Beirne, spreadsheet auditor

Patrick provides consultancy and training in spreadsheet development, auditing / testing and model review; and the Excel addin XLtest

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

VBA code for Microsoft Text Translator API

Microsoft are retiring the Translation API in the Datamarket on April 30, 2017. You need to sign up to the Azure Portal and use the Text Translator API in Cognitive Services. https://translatorbusiness.uservoice.com/knowledgebase/articles/1078534-microsoft-translator-on-azure Action Required before April 30, 2017: Microsoft Translator … Continue reading

Posted in Excel/VBA, Open Source, Productivity | Tagged , | 1 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

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