Chapter One. Why Develop with Office and VBA?

To some people, the idea of using Microsoft Office as a solutions development tool may sound a bit strange. On the one hand, Office is a set of business productivity applications, each designed to perform a specific task— Word processes text, Excel manipulates numbers, Outlook manages e-mail, and so on. On the other hand, solutions development means the creation of custom programs to fulfill specialized needs. The two seem incompatible— how can you use fixed, defined purpose programs to create custom solutions?

Not too long ago, the answer to this question would have been “You can't.” Application programs did their specialized job and that was that. You might at best be able to do some minor customization ...

Get Office® XP Development with VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.