Is VBA Still Relevant 2019?

by | Last updated on January 24, 2024

, , , ,


VBA will never completely go away

because too many companies have invested in it. Microsoft will continue to push JavaScript APIs as the new VBA replacement across all it's platforms (PC, Mac, Tablet, Browser) VBA is still something that should be learned and can easily differentiate you from other Excel users.

Is it worth learning VBA in 2020?

It is

still useful to

learn VBA because it is a great starting point for people who aren't familiar with the world yet. You will be able to use what VBA teaches you when you're expanding your skillset further; it's a great way to start learning more about programming.

Is VBA still supported by Microsoft?

NET

Visual Basic is no longer supported or updated by Microsoft

, the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 in Microsoft Office applications. … However, VBA code normally can only run within a host application, rather than as a standalone program.

Is VBA still in demand?


VBA has been in decline

for professional developers (real coders) for about a decade now as tools such as Python, C#, R or even just Power Query are commonly used to replace VBA or regular Excel. … Many companies both large and small still rely heavily on VBA to automate tasks.

Is VBA still relevant in 2020?

VBA is not as dead as you think.

In 2020,

VBA still shows twice as much interest as a popular programming language

that can be used to automate Excel. (The most loved programming language is Rust. VBA shows 7 times the level of interest as Rust.)

Is Python better than VBA?


Python is better than VBA for data analysis

because it is more powerful and cleaner. Data analysis using Python also provides better version control. VBA is only suitable for simple Excel automation as it's built for that. If you want to do anything more complex, you are better off using Python.

Can Python replace VBA?


Yes, absolutely!

VBA is commonly used to automate Excel with macros, add new user defined worksheet functions (UDFs) and react to Excel events. Everything you would previously have done in Excel using VBA can be achieved with Python.

What is the future of VBA?


VBA is not the future

, definitely. But VBA support will continue till Excel / Office is continuing. There are 100s of millions lines of VBA code supporting very critical processes. This issue has been discussed almost every year and outcome is that VBA will continue.

Should I learn VBA or Python first?

If you want to build independent (standalone) applications, then

learn Python

. On the other hand, if you simply want to automate laborious and repetitive task in Office applications, then go with VBA. Finally, if you have limited time, then you should definitely learn VBA.

Is Power Query better than VBA?

Power Query is like a machine because once you have your query setup, the process can be repeated with the click of a button (refresh) every time your data changes. If you have used macros to transform your data, you can think of this as a

much easier alternative

to VBA that does NOT require coding.

Will Microsoft get rid of VBA?


VBA will never completely go away

because too many companies have invested in it. Microsoft will continue to push JavaScript APIs as the new VBA replacement across all it's platforms (PC, Mac, Tablet, Browser) VBA is still something that should be learned and can easily differentiate you from other Excel users.

Is Visual Basic 6 dead?

This means that the Visual Basic development environment and associated runtime environments (except for Visual Basic 6) are no longer supported. In a way,

VB6 is dead because it is no longer being developed by Microsoft

. … NET Framework in 2001, along with a new language C# and an updated Visual Basic . NET version.

Is Visual Basic Dead 2020?

Visual Basic (VB.NET) will continue to be supported by Microsoft. (

It's not dead

.) The language will no longer have new features added to it. (It's done.)

Is VBA hard to learn?

With the right training, learning Microsoft

VBA is easy

. The Microsoft VBA Introduction course makes it easy to learn VBA primarily for Excel. There's also an Advanced VBA training course if you're looking for a higher difficulty level.

Can Python replace Excel?


You can now replace Excel with Python

and never look back. If you are hooked, try 30 days of Pandas.

What is VBA good for?

You can use VBA in Excel to

create and maintain complex trading, pricing, and risk-management models, forecast sales and earnings

, and to generate financial ratios. With Visual Basic for Applications, you can create various portfolio-management and investment scenarios.

Charlene Dyck
Author
Charlene Dyck
Charlene is a software developer and technology expert with a degree in computer science. She has worked for major tech companies and has a keen understanding of how computers and electronics work. Sarah is also an advocate for digital privacy and security.