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