This post is still under development but here’s a dump of all issues. Hopefully I’ll get around to finishing it some day 👀 Issues with the language Object creation and method call is slow when compared to modern languages (and compared to module only code). Hidden features which are unimplementable - e.g. unable to implement IEnumVARIANT. I.E. No custom For each ... in ... next implementations (unless you delegate to a collection) Some low level standard interfaces are forbidden in VBA...| VBA Articles
In the 2020 StackOverflow survey, it is claimed that VBA is the most dreaded language: In this article we will explore some of the reasons why this might be the case. Who uses VBA? In order to answer this question we must first look at another question - who actually uses VBA in the first place? In 2021 I ran a poll on /r/vba where I asked redditors why they code in VBA. From these data we can clearly see that the majority of people who use VBA do so mainly because they have no other choice. ...| VBA Articles
Last week, I had a fascinating conversation with a reader around frustration and unhappiness at work. Much of it was totally obvious to both of us, but it occurred to me that this probably isn't to everyone, which is why almost all of my colleagues (in very cushy, non-stressful jobs) nonetheless need therapy. And if it isn't obvious to everyone, it's worth writing about.| ludic.mataroa.blog