This book is designed for novice and intermediate Office developers and should attract a broad audience, including programmers, office managers, IT staff, and individual users of the Office suite of applications. In other words, the book has value for everyone who wants to be more efficient. The book shows how to exploit the Office applications by learning how to develop solutions to common business problems. The reader will understand how to solve those problems using the many utilities, features, hidden shortcuts, Wizards, add-ins and other tools in the Office suite. The book is also for would-be developers who want to get involved in customizing or automating the applications, but just don't know how to get started. Whether they want to get Access to communicate with Outlook, or they're interested in building a sophisticated inter-office scheduling system--they'll find what they need in this book.
Contents
Introduction.
Book I: Office 2003 Essentials.
Chapter 1: Getting with the Program.
Chapter 2: Programming Lite: Making the Most of Macros.
Chapter 3: What’s New in 2003?
Book II: Understanding Office Programming.
Chapter 1: The Basics of Office Development with VBA.
Chapter 2: Managing Data.
Chapter 3: Looping and Branching.
Chapter 4: Managing Files and UserForms.
Chapter 5: Moving to the Internet.
Chapter 6: Debugging.
Book III: Maximizing Word.
Chapter 1: The Word Object Model.
Chapter 2: Power Editing.
Chapter 3: Using XML in Word.
Chapter 4: The Internet Connection.
Chapter 5: Advanced Word Macros.
Book IV: Making the Most of Excel.
Chapter 1: The Excel Object Model.
Chapter 2: Handling Excel Events.
Chapter 3: Advanced Worksheet Editing.
Chapter 4: Data Diving with Pivot Tables.
Chapter 5: Business Analysis with Excel.
Chapter 6: Ten Excellent Excel Macro Techniques.
Book V: Advanced Access.
Chapter 1: Access Today.
Chapter 2: Programming Access.
Chapter 3: Manipulating Datasets.
Chapter 4: Automating Access.
Chapter 5: Troubleshooting in Access.
Chapter 6: Access Macro Techniques.
Book VI: Exploiting Outlook.
Chapter 1: Outlook Power Tools.
Chapter 2: Programming Outlook.
Chapter 3: Managing Work and Life.
Chapter 4: Expert E-Mail Administration.
Chapter 5: Group Management in Outlook.
Chapter 6: Advanced Outlook Macros.
Book VII: InterOffice: Working as a Team.
Chapter 1: Collaboration Features Overview.
Chapter 2: Managing Shared Documents.
Chapter 3: XML and Office.
Chapter 4: Working with InfoPath.
Chapter 5: Adding Smart Tags.
Chapter 6: Exploring Smart Documents.
Chapter 7: Using Project 2003.
Chapter 8: Employing SharePoint.
Book VIII: Power Techniques: Advanced Office Automation, VBA, and .NET.
Chapter 1: Advanced Office 2003 Programming.
Chapter 2: Exploring XML.
Chapter 3: Employing Objects.
Chapter 4: Advanced Internet VBA.
Chapter 5: Working with .NET.
Chapter 6: Using Visual Studio Tools for Office 2003.
Chapter 7: Office 2003 Security.
Chapter 8: No More Paranoia: Programmatic Encryption.
Index.
Richard Mansfield (High Point, North Carolina) has written 36 computer books. As Editor of Compute! Magazine, he has written hundreds of magazine articles and two columns. From 1987-91, Richard was editorial director and partner in Signal Research and began writing books full-time. Among his recent titles are Visual Basic .NET All-in-One Desk Reference For Dummies, XML All-In-One Desk Reference For Dummies (with Richard Wagner), and Visual Basic .NET Database Programming For Dummies.