1 Open the AutoExpansion Macros dialog box: On the Tools menu, click, Macros.

2 Click the tab for the type of your macro: mrScriptBasic, mrDataManagementScript or mrMetadataScript.

3 In the Macro Name box, enter a name for the new macro.

4 In the Macro Text box, type the code that you want the macro to insert. You can define parameters by inserting numbers in braces. The parameters must be numbered in ascending order, starting with 0 (for example, {0} and {1}). When you subsequently use the macro, you can supply arguments to replace the parameters.

5 Click the Add Macro toolbar button.