Word Document Properties

Message box:
Many of my examples in this chapter use message boxes,
which is the standard method that most programs use.
Text file:
You can create a text file with error information. A formatted
text file — one that uses tabs to separate individual entries — can act as
input to a database. See Chapter 10 for details on working with disk files.
Windows Event Log:
You can use a Windows Event Log entry to hold the
error information. The Event Log uses a standard format for error mes-
sages. It’s the place where a network administrator looks for errors.
E--mail:
You can create an e-mail message with error information about
your program. See Chapter 16 for details on working with Outlook from a
VBA program.
146
Part II: Learning the Ropes 
11_046500 ch06.qxp 12/5/06 5:35 PM Page 146

---

Saving and Restoring Code
Some VBA code is generic, which means that you can use it in more than one
place. Keeping this code in a separate module that you move from applica-
tion to application is always a good idea. When you use generic modules, you
write the code once and then you always have it when you need it. This sec-
tion describes how to export modules from one application and import them
into another.
Exporting a module from a program
When you work with VBA, you might create some modules that you want to
use in other places. This means exporting your module to a BAS (BASIC) file.
(Forms rely on the FRM file, and class modules rely on the CLS file.) The fol-
lowing steps tell you how to perform this task.
1. Highlight the module, form, or class module that you want to export
from a program in the Project Explorer window.
2. Right-click the entry and then choose Export File from the context