Datasheet

Book VIII
Chapter 1
What the Heck
Is VBA?
Discovering Code as You Go
589
A dialog box appears, asking whether you want to include error-handling
code or comments in the code. If you want to keep the code relatively
simple, you can clear the first option and select only the second option.
5. Click the Convert button and then click OK when your conversion is
complete.
To see the name of the converted macro, expand the Modules category as in
Figure 1-18. The name of the module is
Converted Macro - followed by
the name of the macro you converted.
To see the converted macro as VBA code, double-click its name. Like all VBA
code, the code from the converted macro opens in the Visual Basic Editor
Code window, as shown in Figure 1-19.
Figure 1-19:
Converted
macro in
Code
window.
Figure 1-18:
TinyMacro
converted
to module
named
Converted
Macro -
Tiny
Macro.
38_036494 bk08ch01.qxp 11/17/06 8:34 AM Page 589