Word Document Properties

Part II: Learning the Ropes 
08_046500 ch03.qxp 12/5/06 5:34 PM Page 70

---

Writing Your First Sub
Most Microsoft Office products provide a Properties dialog box, similar to
the one shown in Figure 3-10, that contains a Summary tab for documents.
You can also find a variation of this Properties dialog box for most third-party
products. The Summary tab can provide a lot of valuable information for
your programs. You can find out basic statistics, such as the author’s name
and the company that created the document. The document information also
includes statistics, such as the number of words that the document contains.
See the BuiltinDocumentProperties help topic in the VBA help file for addi-
tional information.
Unfortunately, Office 2007 products that rely on the Ribbon interface hide
the Properties dialog box. The following steps describe how to display the
Properties dialog box shown in Figure 3-10:
1. Click the Office button to display the Office menu.
2. Choose Finish
➪
Properties.
The Office product displays the standard proprieties list.
3. Click Standard.
You see an Advanced option on the drop-down list that appears.
4. Click Advanced.
The Properties dialog box shown in Figure 3-10 appears.
Figure 3-10:
Many
applications
include a
Summary
tab, like
this one.
71
Chapter 3: Writing Structured VBA Programs
08_046500 ch03.qxp 12/5/06 5:34 PM Page 71

---

This is the first example where you work directly with an object. The property
that you want to use is 
BuiltinDocumentProperties
. This property is
available for most of the Microsoft Office products, but it’s attached to a dif-
ferent object in each one. When using Word, you find this property attached
to both the 
Word.Document
and 
Word.Template
objects. Excel users find
the property attached to the 
Excel.Worksheet
object. Use Object Browser
(press F2 to display Object Browser, if necessary), which I discuss in Chapter 1,
to find this property for your product. Type