What is Microsoft Excel VBA?

The code that the MS Excel VBO uses to operate Excel is a programming language called Visual Basic for Applications (VBA). The language has its roots way back in the day when Visual Basic (the original version before ASP.NET came into the picture) was in its heyday.

While Visual Basic has since been superseded by Visual Basic.NET, VBA still lives on. It has been embedded in many Office applications, Excel and Word included, as a power tool for us to get more out of the application than what is available out of the box. We use VBA to write macros, perform complex calculations, and to execute simple programming tasks, such as connecting to an external data store to download data into a spreadsheet.

The nice thing ...

Get Robotic Process Automation with Blue Prism Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.