Office XP Development with VBA

• Create custom business solutions with Microsoft Office XP and Office 2000!
• Extend Word, Excel, Outlook, and other Office applications.
• Learn all aspects of Office development, including security and distribution.
• Leverage Office's powerful collaboration, intranet, and Web capabilities
• For novice developers and Office power users!
• Discover the power of Office programming
• Applies to both Office XP and Office 2000
• Master the Visual Basic for Applications (VBA) language and development environment
• Understand the powerful components in the Office object model
• Build custom tools that leverage email and the Web
• Construct four Office applications - step-by-step
• No Microsoft Office programming experience necessary!

Developing robust custom solutions with Microsoft Office XP/2000!Microsoft Office is far more than the world's leading office productivity suite. Itspowerful capabilities are organized into hundreds of programmable components, all available to any developer who needs to create custom business solutions. Bycombining these components with the powerful Visual Basic for Applications (VBA) programming language, you can construct powerful applications far more quickly than if you built them from scratch. These components and VBA are available in both Office XP and Office 2000, which means you can use them whether or not you upgraded.

In this book, expert developer and consultant Peter G. Aitken shows exactly how toleverage the power of Microsoft Office in custom application development. Whetheryou're an experienced developer or a busineswith a problem that needssolving, Aitken will show you how to do it with Office — step by step.

Aitken begins by reviewing each key Office application - Word, Excel, Access,PowerPoint, Frontpage, and Outlook - and the shared components accessible to all ofthem. You'll discover powerful opportunities for extending and automating Office to increase efficiency and improve collaboration throughout your organization. Then, onestep at a time, Aitken teaches the key VBA skills you'll need to achieve your goals. Finally, this book walks you through the construction of four real-world Office applications, emphasizing the potential value of Office custom solutions in real-world business situations.

Contents

Preface.

I. INTRODUCTION TO OFFICE DEVELOPMENT.