Author Archives: Patrick O'Beirne, spreadsheet auditor
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
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
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
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
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
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
