- Report this article
Sanjay T S
Sanjay T S
Manager - AI | ML
Published Apr 20, 2023
+ Follow
Is VBA about to become extinct? Investigating the Fall in Popularity of Visual Basic for Applications
VBA is a programming language that is integrated with Microsoft Office applications such as Excel, Word, and PowerPoint. It enables users to automate activities, implement custom functions, and create apps within the Office environment. However, VBA's popularity has been waning in recent years, and many are concerned about its future.
VBA's decline might be linked to a variety of things. For starters, VBA is an old technology that hasn't been upgraded in years. It was initially introduced with the release of Excel 5.0 in 1993, and there have been minimal improvements to the language since then. As a result, VBA has failed to keep up with the fast changing technological scene, and many developers are seeking more current languages.
Second, the rise of alternative languages and platforms has led to VBA's demise. Python, for example, has grown in popularity as a data analysis and automation language, and its simplicity and versatility make it a great contender to replace VBA. Other platforms, including as Google Sheets and Airtable, provide significant automation features that compete with VBA.
Third, the shift to cloud-based apps has undermined VBA's utility. VBA is not supported by cloud-based applications because it is built for desktop applications. The necessity for VBA is decreasing as more enterprises migrate to the cloud.
Despite these challenges, VBA continues to have a large user base and is a crucial tool for many enterprises. However, VBA's supremacy is clearly fading, and developers are increasingly opting for more current languages and platforms.
Microsoft has been investing in new tools and languages to replace VBA in response to this trend. Power Automate, a cloud-based automation platform that connects with Microsoft Office products, is one such solution. Power Automate enables users to automate processes and create unique workflows without using VBA.
Recommended by LinkedIn
Office Scripts, a new scripting language designed to replace VBA, is another option. Office Scripts is a cloud-based programming environment that is more accessible and user-friendly than VBA.
Finally, the demise of VBA can be ascribed to old technology, the rise of alternative languages and platforms, and the shift to cloud-based applications. While VBA retains a sizable user base, its supremacy is clearly diminishing, and developers are increasingly opting for more modern options. Microsoft's investment in new tools and languages, such as Power Automate and Office Scripts, demonstrates the company's awareness of this trend and dedication to giving developers with the tools they need to stay ahead of the curve.
#VBA #MicrosoftOffice #Automation #Python #CloudComputing #PowerAutomate #OfficeScripts #ModernProgramming #DataAnalysis #TechnologyTrends
#TechMegalodon #Godsplayground #20042023
TechMegalodon
TechMegalodon
979 followers
+ Subscribe
Like
Celebrate
Support
Love
Insightful
Funny
8
1 Comment
william vogt
SAP Warehouse Facilitator/VB Automation Developer
6mo
- Report this comment
The answer is no, this has been an argument forever. MS wants to dump it for the more Profitable Power Automate. The issue is PowerBI users want MS to add VBA to it. Even though it has Rust and Python support. People want VBA for it, I do alot of Automation VBA, VBscripting, there are VBA users out there that developed wrappers for VBA to do OpenCL. I am making a program that connects to an chatGPT, and connects VBA/VBscripts to do automation on the fly. They say VBA is only for automating office products, Google chrome is not office, but I did some automation with VBA because the Web portal has no API and I had to make 30 reports. Python, I have watched videos of users with different models for GPT and there were conflicting environment setups or he had to chase down the imports. VB solutions work right out of the box, although MS does not develop for it anymore, there are users still adding features to it. When I have to transfer data directly into an Excel I use VBA as the Power Query is slow.
1Reaction 2Reactions
To view or add a comment, sign in
More articles by this author
No more previous content
- Dialogue Between Two IVRs Jul 1, 2024
- Meta Unveils New AI Framework Jul 1, 2024
- Unprepared for Employment: Examining the Readiness of the Modern Generation Sep 15, 2023
- Unraveling the Complexity of Prompt Engineering Sep 6, 2023
- Engineering Prompt Analysis: Leveraging Language Model (LLM) for Data Dictionary Examination Sep 5, 2023
- Exploring the Significance of Proximity Analysis in Geographic Insights Sep 1, 2023
- Demystifying the Functionality of Microsoft 365 Copilot Aug 31, 2023
- Prioritizing PII Masking: The First Step in Safe Data Analysis Aug 29, 2023
- Unveiled Potential: Understanding Why New Products Falter in the Marketplace Aug 29, 2023
- Enhancing Geotagging with Language and Vision: Leveraging LLM Technology Aug 28, 2023
No more next content
Sign in
Stay updated on your professional world
Sign in
By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.
New to LinkedIn? Join now
Insights from the community
- Statistical Programming What are the best practices for writing and testing SAS macros?
- Data Architecture How can you version control a T-SQL stored procedure?
- Data Analytics How can you write and run R scripts in different environments?
- Programming What are the best practices for designing an API with multiple data formats?
- Analysis Services How do you automate SSAS testing with Visual Studio and SSIS?
- Programming How do you choose the right data types for generic programming?
- Quantum GIS How do you compare and merge QGIS styles as XML files using version control or diff tools?
- Language Integrated Query (LINQ) How do you write and run C# scripts and interactive tutorials with LINQPad?
- Business Analysis What are the steps to using VBA macros in Excel for data analysis?
- Application Programming Interfaces How do you design an effective data catalog for application programming?
Others also viewed
- An Ant Analogy to Ruby and SQL scripts for ICM SWMM and ICM InfoWorks on our Github Robert Dickinson 7mo
- Out of the Shadows: Explore a Database Projects’ Inner Workings using SSDT Schema Compare Dan Romano 1y
- Excel for ENGINEERS Rahul Harale 1y
- Why LINQ beats SQL RAUNAK DEEP SRIVASTAVA 8y
- Oracle Developer Tools for Visual Studio - Part 1 Anil Mahadev 3mo
- Excel - SWITCH Function Excel BI 3y
- Compare And Update SQL Server Database Project With Visual Studio Habib ul Rehman 3mo
- AI Apps on your Phone? Visual Basic points the way Dave Holmes-Kinsella 2mo
- Are Office Scripts the new VBA? David Wyatt 2y
Explore topics
- Sales
- Marketing
- IT Services
- Business Administration
- HR Management
- Engineering
- Soft Skills
- See All