What are some applications of VBA?

With VBA you can create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports. VBA functions within MS Office applications; it is not a stand-alone product.

Microsoft Excel VBA allows for automating tasks in Excel and provides a full programming environment for data analysis. Excel VBA is commonly used in high finance and frequency trading applications for creating and validating financial models.