IT departments have significant other responsibilities other than automation and application development. VBA shows 7 times the level of interest as Rust.) VBA is being used primarily by non-IT users.Ī major reason why VBA is being used so frequently is that it does not require resources from an IT department. (The most loved programming language is Rust. In 2020, VBA still shows twice as much interest as a popular programming language that can be used to automate Excel. Excel automation can also use TypeScript to create Office Scripts which can be used to automate Excel Online.ĭespite it’s popularity with programmers, TypeScript is not generating as much interest as VBA. Given that it is so despised, it should be notably less popular than the second most popular language. How is this possible when VBA is the “ most dreaded programming language” according to Stack Overflow in 2020? VBA is not as dead as you think. Are business and technical users turning to other solutions to automate Excel?Ī quick search on LinkedIn shows that there are still over 15 thousand jobs that are requesting VBA. Popularity in the language has dropped over 60% from it’s peak in 2004. As a programming language that was available for business users, millions of macros have been created in VBA. Since 1993, Visual Basic for Applications has been the first choice for Excel automation.

Visual basic for excel reddit