

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.
