What are the advantages of VBA?
First, there is strength in numbers, and by far VBA is the most commonly used macro language for applications. A benefit of learning VBA is that once you master the language, you can more readily write macros for other applications. Another major advantage of VBA is that the platform makes it easier to connect to other applications via COM (Component Object Model), such as databases and third-party applications.