Posted by & filed under VBA.

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

Comments are closed.