Introduction to VBA

 VBA| Introduction to VBA | Part-1

VBA | VBA also known as "Visual Basic for Applications" is another programming language which is developed and owned by Microsoft. With VBA we can automate various applications such as Outlook, Word, Excel, Web Scrapping and we can use excel as database in VBA and many more applications.

Now we will take a look at some of the key points of VBA which are as follows:-

1. VBA is also known as Visual Basic for Applications.
2. VBA is a programming language which is developed and owned by Microsoft.
3. With VBA we can create macros to automate repetitive tasks such as word and data processing functions and also we can generate custom reports, graphs and forms.
4. VBA functions with MS Office application since it is not a standalone product.

Let us now see the advantages and disadvantages of using VBA which are as follows:-

Advantages:-

1. It always executes the task in exactly the same way as it is expected to perform.
2. It performs the task much faster as compared to the employees or the resources performing the same task manually.

Disadvantages:-

1. We need to know about how to write the program/code in VBA.
2. Other people who want to use VBA must have their own set of copies of excel on their system or desktop or machine.

In the next blog we will discuss about the Developer Tab and the VBA Architecture.

In case if you have any queries then do please feel free to reach out to me with your queries in the comment section and I will be more than happy to respond to your queries. 

Comments and suggestions for improvement are always appreciated.