In the previous chapter, we mentioned that VBA was Excel’s programming language. It turns out that VBA is the programming language for all the Microsoft Office applications. Also VBA is becoming the programming language of other popular applications. Some of the other applications that are using VBA as its programming language are Visio and Business Objects. This is very exciting news for people who automate applications. The main advantage is that a person does not have to constantly learn a new language when he or she deals with a new application. Another important advantage of an application adopting VBA as a programming language is it is a language that uses most of the programming concepts that professional programmers use; therefore, VBA is a powerful language. Now, it is easier for an Excel programmer to do Access VBA programming, Word VBA, or even PowerPoint VBA programming. The finance people would say that there is a return in the investment of time in learning VBA.
Keywords
- Object model
- Object browser
- References
- Type library
- Variables
- Data type
- Option explicit
- Object variables
- Functions
- If statement
- For loop
- For Each
- While loop
- Arrays
- Option base
- Collections
- Byte
- Boolean
- Integer
- Long
- Single
- Double
- Currency
- Decimal
- Variant
- String