Microsoft Office 2000/Visual Basic Programmer's Guide   

Preface

The Microsoft Office 2000/Visual Basic Programmer's Guide describes how to use the applications and components in Microsoft Office 2000 to build custom solutions. This guide is the definitive resource for developers who are creating custom solutions based on Office applications. From the overall design of your solution to the nitty-gritty details of implementing it, this book tells you what you need to know to get things done quickly and productively.

If you are familiar with one of the Office applications, you can build on that knowledge to work with other applications in the suite. If you know how to work with Visual Basic for Applications (VBA), you'll learn how to build on that knowledge in order to create code modules you can reuse in any application. If you've designed database solutions, you can build on that knowledge in order to create data-driven Web pages that your users can interact with through a Web browser.

Even if you're an expert programmer in one or more of the Office applications, figuring out where to get started when you are building a solution can be a daunting task. The applications and components that make up Microsoft Office expose hundreds of programmable objects that you can manipulate through VBA code. Each of those objects exposes a number of properties and methods that you can use to specify how the object behaves. The prospect of dealing with all these objects can be challenging, but the Microsoft Office 2000/Visual Basic Programmer's Guide will show you where to get started.

Office developers have asked for a resource like the Microsoft Office 2000/Visual Basic Programmer's Guide for a long time. That time has finally arrived. This guide teaches you how to capitalize on your existing knowledge in order to take full advantage of new and existing features alike. This book is about mastering new and existing technologies, and learning strategies and skills that you can apply to all of your Office programming tasks.

Not only is the information presented here something you can use immediately, but also each chapter includes dozens of code samples to help illustrate the discussions. In addition to the code samples shown in the chapters, the Office 2000 Developer CD-ROM contains hundreds of VBA and Microsoft Visual Basic Scripting Edition (VBScript) procedures that you can use right now in your own solutions. The Office 2000 Developer CD-ROM also includes white papers that provide in-depth discussions of various technologies and programming issues not covered in the book. Lastly, the Microsoft Office 2000 Object Model Guide includes complete object models for every Office application and component. In short, the Microsoft Office 2000/Visual Basic Programmer's Guide contains just about everything you need to know to start building custom solutions with Office.

Contents

Who This Guide Is For

How to Use This Guide