What is VBA ?
VBA is short for Visual Basic for Applications. It is a powerful interactive programming language which tightly integrates with the Microsoft Office. It support a BASIC-like command structure whose interpreted coding style makes it an ideal scripting tool for the Office family of applications. Also it inherently supports OLE automation.
In the dark days of Windows application programming, the developer had to struggle with the vast array of functions called the Windows API. This had to be tightly coupled with the main procedures and the something called the ‘Message-Loop’ which is used by windows to process events. Visual Basic changed all that by providing the developer with a simple intuitive BASIC-like syntax to program Windows applications. This concept radically changed the world of Windows programming and brought the arcane art to the mainstream.