Developing Microsoft Office Solutions: Answers for Office 2003, Office XP, Office 2000, and Office 97

Build custom Microsoft Office solutions that solve real business problems--fast!Now, there's a practical, easy-to-use guide for every developer and power user who wants to solve real business problems with custom Microsoft Office applications.Packed with case studies and code examples, this book covers all of Office, not just one product. Ken Bluttman shares more than a decade's experience as an Office developer, demonstrating how to program every recent version, from Office 2003 back to Office 97. Working with Office 2003? You'll discover exactly how to make the most of its breakthrough XML support--including schemas, transformations, and more! Everything you need to know to develop custom Office applications:Covers Word, Excel, Access, PowerPoint, Outlook, and InfoPathClearly explains the key Microsoft Office objects and methodsShows how to integrate multiple Office applications into a complete solutionIncludes full chapters on XML, InfoPath, and Smart TagsIncludes five chapter-length case studies! A custom mail merge application with Access and WordCreate PowerPoint graphs with Excel dataAutomated Excel charts from imported XML data Using Word to repurpose raw XML data into useful content Using Microsoft's XML parser to overcome Office 2003 XML limitations

Table of Contents:
Preface. I: OFFICE DEVELOPMENT. 1. What's New for Developers in Office 2003. Increased XML Support. Enhanced Smart Tags. Smart Documents. InfoPath. The Research Task Pane. Other New Office Enhancements for Developers. Summary. 2. Word Solution Development. Objects, Properties, and Methods. Events. Summary. 3. Excel Solution Development. Objects, Properties, and Methods. Events. Summary. 4. Access Solution Development. Objects, Properties, and Methods. Summary. 5. PowerPoint Solution Development. Objects, Properties, and Methods. Events. Using VBA with PowerPoint in Design Mode. Using VBA with PowerPoint Slide Shows. Summary. 6. Outlook Solution Development. Objects, Properties, and Methods. Events. Summary. II: OFFICE TECHNOLOGIES. 7. Common Microsoft Office Objects. File Search. File Dialogs. Command Bars. Summary. 8. Microsoft Forms. When to Use Forms Instead of Standard Screen Components. Creating a Form. Adding Code. Form and Application Interaction. Summary. 9. XML and Office. XML and Word 2003. XML and Access 2003. XML and Excel 2003. XML Maps. Using the MSXML Parser to Work with XML Data. Summary. 10. Smart Tags. The Smart Tag Schema. Saving and Using Smart Tag Files. Using Smart Tags in Word and PowerPoint. Using Smart Tags in Excel. Using Smart Tags in Access. Summary. 11. Introduction to InfoPath. Overview. InfoPath File Types. Designing Forms. Step-by-Step Form Design. Programming InfoPath Forms. Summary. III: CASE STUDIES. 12. Mail Merge Magic. The Problem. The Requirements. Solution Tool Set and Files. Notes on This Case Study. The Structure of the Customers Database. Using the Solution. The Main Form. What Happens When the Document Is Opened. Inserting Content from Another Document. Saving the Content from the Solution Document. The Query Form. Running a Query. Summary. 13. Dynamic Data Delivery. The Problem. The Requirements. Solution Tool Set and Files. Notes on This Case Study. Excel Workbook Development. PowerPoint Presentation Development. Summary. 14. Charting XML Data. The Problem. The Requirements. Solution Tool Set and Files. Notes on This Case Study. XML Data. At Startup. The Solution Code. Preparing the Workbook. Bringing the Data into the Workbook. Using the MSXML Parser to Import. Processing the Data for Use in Charts. Creating the Charts. Applying Variations of the Top and Height Properties. Summary. 15. Repurposing XML Content. The Problem. The Requirements. Solution Tool Set and Files. Notes on This Case Study. The Structure of the Source XML Files. The Structure of the XML Schema. The Structure of the Word Template. Saving the Template. Using the Template. Adding the Comments. Running the Transformation. Saving the New View. Summary. 16. Applying Saved InfoPath Data. The Problem. The Requirements. Solution Tool Set and Files. Notes on This Case Study. The InfoPath Form. XML Created with InfoPath. The Related Access Tables. Using the MSXML Parser to Import the Data. Summary. Appendix Resources. Index.

About the Author :
Ken Bluttman has been developing custom Office solutions for more than ten years. He has consulted for dozens of companies, including leading firms in finance, insurance, energy, and health care. He also develops Oracle and SQL Server database applications, XML applications, and a variety of Web sites. Ken lives in New York with his wife, son, and dog. 0201738058AB10072003