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
How to improve performance of VBA macros is a common question on the VBA reddit. In this section we will provide examples of code, and test their performance against eachother. We believe it is best to work by example and hope this will give you ideas of how you can improve performance in your projects.| VBA Articles
Introduction Recently, I watched a video by YouTuber ThePrimeTime which details a dev’s frustrations with business culture. Prime is an ex-entrepreneur who currently works in software development at Netflix. His views in this video have been criticised for being jaded by FAANG business cultures he has worked in. I personally don’t feel this way. Although there is some truth to the developer’s (mataroa’s) article, I think it misses the root causes of many issues raised. I have mixed fe...| VBA Articles