Q1: | What types of applications most benefit from the use of macros? |
A1: | Single-user or small departmental applications most benefit from the use of macros. |
Q2: | What are some of the main limitations of macros? |
A2: | You cannot include error handling, user-defined functions, variables, parameters, OLE automation, DDE, transaction processing, or Windows API functions within macros. Macros do not allow you to process table records a row at a time or create database objects at runtime. It is also much more difficult to debug macros than it is to debug VBA code. |
Q3: | What is the purpose of the Macro Names column of a macro? |
A3: | The Macro Names column allows you to place multiple routines in one macro. |