Will VBA be obsolete from excel? (2024)

FAQs

Will VBA be obsolete from excel? ›

No, it is extremely unlikely that Microsoft will ditch VBA.

The ad you linked to goes on to confirm that the answer to their own question is No, VBA is too firmly entrenched to be abandoned although it will not be enhanced beyond its current state.

Yes, people still use Excel VBA to run their business operations even in 2024. VBA is a powerful tool that allows its users to work efficiently by helping them create custom functions using scripts or codes in Excel.

NET Visual Basic, which is no longer supported or updated by Microsoft (except under Microsoft's "It Just Works" support which is for the full lifetime of supported Windows versions, including Windows 10 and Windows 11), the VBA implementation in Office continues to be updated to support new Office features.

Everything you can write in VBA can be done in Python. This page contains information that will help you translate your VBA code into Python. Please note that the Excel Object Model is part of Excel and documented by Microsoft.

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.

No, it is extremely unlikely that Microsoft will ditch VBA. There are far too many solutions all over the world that rely on it.

Is VBA Still in Demand? Yes, VBA is still useful and used by individuals who are interacting with Microsoft products but newer languages such as Python, C#, or R can be used to code in place of VBA. New tools such as Power Query may be able to perform tasks that could previously only be performed when using VBA.

However, VBA can be limiting for more complex data manipulation tasks and is generally considered less powerful than Python. On the other hand, Python, with its vast array of libraries provides a more robust solution for complex data cleaning tasks.

In summary, if your focus is on automating and customizing Microsoft Office applications, then VBA is likely the better choice. However, if you need a more general-purpose programming language that can be used for a variety of tasks, then Python may be the better option.

Who still uses VBA? ›

Finance industry professionals, particularly Financial Analysts, use VBA for tasks such as analyzing corporate data, creating financial models, and performing scenario analysis.

Excel isn't obsolete; it's evolving. In the hands of a skilled BI professional, it becomes a powerful tool for unlocking actionable insights from construction data. So, the next time you encounter that humble spreadsheet icon, remember its hidden potential as a BI secret weapon ready to transform your projects.

Disdvantages of vba

The VBA macros work based on the instructions given by the programmer; hence, the execution is based on the instructions. The VBA macro itself cannot do a miracle. The VBA code written in one version may not work on another version; hence, you will have to make necessary edits to execute the code.

No. Such rumors have been doing the rounds for more than 20 years, but they're not true. There are millions of users relying on VBA, including large businesses and organizations.

Visual basic for application is primarily known as VBA, a programming language built into MS Office applications, including Microsoft Excel. VBA can easily automate recurring processes and make boring or regular tasks more convenient.

Office Scripts won't replace VBA, just as VBA won't do everything that Office Scripts does. The two tools serve different purposes in the current ecosystem and will often work best when used together. Excel VBA is best for fast processing and smooth apps that run on desktops.

However, VB6 programs continue to run on the latest versions of Windows due to Microsoft's ongoing commitment to VB6 compatibility. As a result, VB6 applications remain in use across various sectors, including healthcare, retail, finance, construction, and others.

VBA macros are a common way for malicious actors to gain access to deploy malware and ransomware. Therefore, to help improve security in Office, we're changing the default behavior of Office applications to block macros in files from the internet.

You can do some really cool things in Microsoft Office with just a few lines of Visual Basic for Applications (VBA) – from creating your own custom formula in Excel to correcting branded content in PowerPoint to merging address data for a mail campaign in Word.

Is Office going away entirely? No, as part of Microsoft 365 you will continue to get access to apps like Word, Excel, PowerPoint and Outlook. We will also continue to offer one-time purchases of those apps to consumers and businesses via Office 2021 and Office LTSC plans.