Unlike macros, VBA enables you to do the following:
- Work with complex logic structures (case statements, loops, and so on)
- Take advantage of functions and actions not available in macros
- Loop through and perform actions on recordsets
- Perform transaction processing
- Create database objects programmatically and work with them
- Create libraries of user-defined functions
- Call Windows API functions
- Perform complex object linking and embedding (OLE) automation commands