Category Archives: Uncategorized

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

Posted in Excel/VBA, ExcelDna, Open Source, Productivity, Research, Software Quality, Software Testing, Uncategorized | Tagged , | Leave a comment

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

Posted in Excel/VBA, Mac, powerpoint, Uncategorized | Leave a comment

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

Posted in Uncategorized | Leave a comment

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