Microsoft Access 2010 Bible

Chapter 30: Using Access Macros

1079

To try the conversion process, convert the mcrHelloWorldEnhanced macro used earlier in this

chapter. Follow these steps to run the conversion process:

1. Click the Macros group in the Navigation Pane.


2. Select mcrHelloWorldEnhanced.


3. Click the Microsoft Office button, and then click Save As.

The Save As dialog box (shown in Figure 30.21) appears.

FIGURE 30.21

Saving a macro as a module

Access assigns a default name for the new module as “Copy of” followed by the macro
name.

4. Enter a name for the new module and select Module for the As option.


5. Click OK to display the Convert Macro dialog box (shown in Figure 30.22).

FIGURE 30.22

The Convert Macro dialog box

6. Select the options that include error handling and macro comments, and click Convert.

Access briefly displays each new procedure as it’s converted. When the conversion pro-
cess completes, the Conversion Finished! message box appears.

7. Click OK to display the new module in the VBA Editor (shown in Figure 30.23).

Access names the new module Converted Macro- mcrHelloWorldEnhanced.