Author Archives: Patrick O'Beirne, spreadsheet auditor
Extend Excel: London 18 Oct
Charles Williams is organising a conference in London on October 18th, 2018. I’ll be there! This is a rare chance to meet leading developers from all over the world and hear directly from MS on Excel Extensibility. Expect to be … Continue reading
Excel and PowerPoint 2016 for Mac gripes
I’ve been trying to maintain compatibility between Mac and Windows versions of Excel/VBA apps for a while now, and it’s a pain. These notes refer to versions 16.14 of both Excel and Powerpoint. Here are some of my recent threads … Continue reading
Dublin Tech Summit 18-19 Apr 2018
#DTS18 @dubtechsummit Dublin Tech Summit is a two day (Wed 18 and Thu 19 April 2018) meetup of startups and business people intended to connect investors to tech companies, and to highlight emerging tech trends. I attended as a guest … Continue reading
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
