The intermediate code is then executed by a virtual machine (hosted by the hosting application). xls) independent of the document streams. VBA can also be used to create import and export filters for various file formats, such as OpenDocument (ODF).Ĭode written in VBA is compiled to a proprietary intermediate language called P-code (packed code), which the hosting applications (Access, Excel, Word and PowerPoint) store as a separate stream in COM Structured Storage files (e.g. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes. It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word's WordBasic.
It is also built into Office for Mac applications (apart from version 2008), other Microsoft applications such as Microsoft MapPoint and Microsoft Visio as well as being at least partially implemented in some other applications such as AutoCAD, WordPerfect and ArcGIS. VBA enables building user defined functions, automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6 and its associated integrated development environment (IDE), which are built into most Microsoft Office applications. Visual Basic for Applications.rtf (Size: 17.08 KB / Downloads: 40)
0 kommentar(er)
