Microsoft Visual Basic for Applications is a standard object-oriented programming language used in many Microsoft applications and some applications made by other companies, including System Architect and Envision XML.
Microsoft Visual Basic for Applications enables you to program any Microsoft Office application, or any other one that supports Microsoft Visual Basic for Applications. This approach increases efficiency and let you use the same code in different applications.
Differences between Visual Basic and VBA
Visual Basic and Visual Basic for Applications are similar and they both use many of the same commands and objects. The main difference between the two is that you can use Visual Basic to program stand-alone executables and DLL files while Visual Basic for Applications always requires another program such as Word for execution.
Building reports with Visual Basic for applications
You can write Visual Basic for Applications code in Word to get information from the encyclopedia and format it into a Word document. You can use Visual Basic for Applications code to customize and format the reports to your exact requirements. Visual Basic for Applications gives you the functionality of the report generator with the power of a complete programming language with the formatting of a word processor.