Visual Basic for Application (VBA) are an implementation of Microsoft ' s Event-driven programming language Visual Basic 6. Its associated integrated development (IDE) is built into Most Microsoft Office applications. IT enables building user defined functions, automating Processesand accessing Windows API and other low-level functionalit Y through Dynamic-link libraries (DLLs). It is also built to Office for MAC applications (apart to version) and other Microsoft applications such as Micros Oft MapPoint and microsoft Visio, as well as being at least partially implemented on other applications such as Auto CAD, WordPerfect and ArcGIS. It supersedes and expands on the abilities of earlier application-specific macro programming languages such as word ' s word Basic. It can be used to control many aspects ofthe host application, including manipulating user interface features, such as men US and toolbars, and working with custom user forms or dialog boxes. It can also is used to the Create import and export filters for various file formats, such as OpenDocument (ODF).
Just as its name suggests, it's closely related to Visual Basic and uses the Visual Basic Runtime Library, but can no Rmally only run code within a host application rather than as aStandalone Program. It can, however, be used-control one application from another viaoleautomation. It also have the ability to use (but not create) (activex/com ) DLLs, and later versions would add support for class modules.
Visual Basic for Applications