Creating documents, building databases, and writing e-mail are just some of the things you can do with Microsoft Office 2000. But Office 2000 also gives you a way to do these and other tasks, as well as extend built-in functionality, through Microsoft Visual Basic programming. This book shows you how to develop the Visual Basic code that will let your Visual Basic programs automate tasks, tie content together, extend existing functionality, and develop new functionality for Office applications through COM add-ins. You'll learn how to take features beyond their original design in order to meet the needs of your customers or your company.
Microsoft Office 2000 Visual Basic for Applications Fundamentals is organized by task rather than by application. For example, the task of retrieving the current selection in the Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook applications is discussed in one place. The same goes for saving Word, Excel, or PowerPoint documents. Whether you need to develop code that accomplishes a task in any single application or in all of them, you will understand the similarities and differences among the applications. The side-by-side comparisons and code samples give you a way of learning how to write code to accomplish the same task in several Office applications.
The side-by-side comparisons are grouped in the following ways:
This book also describes how to do the following in any Office 2000 Professional application:
IMPORTANT
This book is designed for use with Word, Excel, PowerPoint, Microsoft Access, and Outlook in Microsoft Office 2000 Professional, Premium, or Developer for the Microsoft Windows 95, Windows 98, Windows NT 4.0, and Windows 2000 operating systems. This book is also designed for use with Microsoft Visual Basic 6.0 Professional Edition in order to build COM add-ins for Office 2000. The COM add-in examples in this book, however, can also be used to build COM add-ins with Microsoft Office 2000 Developer. To find out what version of the software you're running, you can check the product package, or you can start Word, Excel, PowerPoint, Access, or Outlook, click the Help menu, and click About Microsoft <product> (where <product> represents the application you started). If the version of your software isn't compatible with this book, a Microsoft Press book for your software is probably available. Please visit our World Wide Web site at http://mspress.microsoft.com/ or call 1-800-MSPRESS for more information.