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; they use many of the same commands and objects. The main difference is that you can use Visual Basic to program standalone executables and DLL files, while Visual Basic for Applications always requires another program for execution such as Word.
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.