Visual Basic for Applications

From OberonPlace Development Portal

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic, and associated integrated development environment (IDE). VBA is included into many applications to enable end-users and 3rd party developers to create custom features for those applications, extend their functionality, as well as automate everyday tasks via using macros and macro recorder. VBA is included with many applications from Corel (CorelDRAW, Corel PHOTO-PAINT, Corel DESIGNER, Corel WordPerfect), Microsoft (Microsoft Office), Autodesk (AutoCAD) and others.

VBA can be used to control almost all aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.

VBA is closely related to Visual Basic, but can normally only run code within a host application rather than as a standalone application. It can, however, be used to control one application from another using OLE Automation. For example, it can be used to open a CorelDRAW document, export it to a bitmap and open the bitmap in Photo-Paint, and all from within Photo-Paint).