Office 2003 XML

In Microsoft's Office 2003 users experience power of the classic Office suite of applications merge red with the fluidity of data exchange inherent in XML. With XML at its heart, the new version of Microsoft's desktop suite liberates the information stored in millions of documents created with Office software over the past fifteen years, making it available to a wide variety of programs.

Office 2003 XML offers an in-depth exploration of the relationship between XML and Office 2003, examining how the various products in the Office suite both produce and consume XML. Developers will learn how they can connect Microsoft Office to others systems, while power users will learn to create and analyze XML documents using familiar Office tools.

The book begins with an overview of the XML features included in the various Office 2003 components, and explores in detail how Word, Excel, and Access interact with XML. This book covers both the user interface side, creating interfaces so that users can comfortably (and even unknowingly) work with XML, and the back end, exposing Office information to other processes. It also looks at Microsoft's new InfoPath application and how it fits with the rest of Office. Finally, the book's appendices introduce various XML technologies that may be useful in working with Office, including XSLT, W3C XML Schema, RELAX NG, and SOAP.
Office 2003 XML provides quick and clear guidance to a anyone who needs to import or export information from Office documents into other systems. Both XML programmers and Office power will learn how to get the most from this powerful new intersection between Office 2003 and XML

Table of Contents

Preface 

1. Microsoft Office and XML

      Why XML? 

      Different Faces of XML 

      Different XML Faces of Office 

      Opening Office to the World 

2. The WordprocessingML Vocabulary

      Introduction to WordprocessingML 

      Tips for Learning WordprocessingML 

      WordprocessingML's Style of Markup 

      A Simple Example Revisited 

      Document Structure and Formatting 

      Auxiliary Hints in WordprocessingML 

      More on Styles 

3. Using WordprocessingML

      Endless Possibilities 

      Creating Word Documents 

      Extracting Information from Word Documents 

      Modifying Word Documents 

      Converting Between WordprocessingML and Other Formats 

4. Creating XML Templates in Word

      Clarifying Use Cases 

      A Working Example 

      Word's Processing Model for Editing XML 

      The Schema Library 

      How the onload XSLT Stylesheet Is Selected 

      Merged XML and WordprocessingML 

      Attaching Schemas to a Document 

      Schema-Driven Editing 

      Schema Validation 

      Document Protection 

      XML Save Options 

      Reviewing the XML-Specific Document Options 

      Steps to Creating the onload Stylesheet 

      Deploying the Template 

      Limitations of Word 2003's XML Support 

5. Developing Smart Document Solutions

      What's a Smart Document? 

      Creating a Smart Document Solution 

      Coding the Smart Document 

      Coding in VB.NET 

      Manifest Files 

      Other Files 

      Attaching the Smart Document Expansion Pack 

      Deploying Your Smart Document Solution 

      A Few Last Words on Smart Documents 

      Some Final Thoughts 

6. Working with XML Data in Excel Spreadsheets

      Separating Data and Logic 

      Loading XML into an Excel Spreadsheet 

      Editing XML Documents in Excel 

      Loading and Saving XML Documents from VBA 

7. Using SpreadsheetML

      Saving and Opening XML Spreadsheets 

      Reading XML Spreadsheets 

      Extracting Information from XML Spreadsheets 

      Creating XML Spreadsheets 

      Editing XML Maps with SpreadsheetML 

8. Importing and Exporting XML with Microsoft Access

      Access XML Expectations 

      Exporting XML from Access Using the GUI 

      Importing XML into Access Using the GUI 

      Automating XML Import and Export 

9. Using Web Services in Excel, Access, and Word

      What Are Web Services? 

      The Microsoft Office Web Services Toolkit 

      Accessing a Simple Web Service from Excel 

      Accessing More Complex Web Services 

      Accessing REST Web Services with VBA 

      Using Web Services in Access 

      Using Web Services in Word 

10. Developing InfoPath Solutions

      What Is InfoPath? 

      InfoPath in Context 

      Components of an InfoPath Solution 

      A More Complete Example 

      Using InfoPath Design Mode 

A. The XML You Need for Office

B. The XSLT You Need for Office

C. The XSD You Need for Office

D. Using DTDs and RELAX NG Schemas with Office

Index