#Learning visual basic for excel reddit code
In either scenario, an unsuspecting business user could run malicious code on a. In order to improve efficiency, business users use VBA since there is no administrative control in place to prevent users from writing macros.įor departments that have heavy reliance on VBA, macros may be fully enabled, or disabled with notification. Providing training or low-code resources (such as PowerApps) can be timely or costly. These responsibilities include administration and tech support, along with customer facing activities such as the corporate web site.Īs a result, the time and resources for automating processes can be very limited. 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.