Word Document Properties

Part IV: Programming for Applications
The main purpose of this part of the book is to help you become productive
by using VBA with a particular application. However, before you begin read-
ing about a specific Office application, in Chapter 12 I show you how to make
4
VBA For Dummies, 5th Edition 
03_046500 intro.qxp 12/5/06 5:32 PM Page 4

---

some Office-specific changes by using VBA code. Make sure that you read
Chapter 12 to understand how the Ribbon interface will affect your existing
applications.
In this part, I discuss the three main Office applications: Word (Chapter 13),
Excel (Chapter 14), and Access (Chapter 15). You probably don’t use just one
application, so in Chapter 16 I extend the idea of individual application pro-
gramming into working with multiple applications by using a single program.
Part V: The Part of Tens
We all accumulate cool tips and techniques that other people find helpful.
Chapter 17 tells about ten kinds of resources that you can use to make VBA
better, easier to use, or simply more productive. Chapter 18 describes ten
ways to upgrade your existing VBA code quickly.
The accompanying Web site
This book contains a lot of code, and you might not want to type it. Fortunately,
you can find the source code for this book on the Dummies.com Web site at
http://www.dummies.com/go/vbafd5e
. The source code is organized by
chapter, and I always tell you about the example files in the text. The best way
to work with a chapter is to download all the source code for it at one time.
The Web site also has three Bonus Chapters: one on FrontPage, a second on
Visio, and a third on ten cool things that you can do with VBA. The FrontPage
chapter describes how you can use VBA to make FrontPage easier to use.
In fact, you’ll find an application that lets you create the initial part of a
Web page automatically. Other programs show how to discover more about
FrontPage features and demonstrate how to customize those features to meet
specific needs, such as exchanging data between applications.
The Visio chapter describes how you can use VBA to automate some Visio
drawing tasks. For example, you’ll discover that you can create Visio draw-
ings significantly faster by automating required setup tasks that you can’t
easily perform using a stencil or template. This Bonus Chapter relies on Visio
2007. Although many of the macros will work with older versions of Visio,
you’ll still want to use Visio 2007 to obtain the maximum benefit from this
Bonus Chapter.
5