Books & Videos

Table of Contents

  1. Chapter 1 Microsoft Office and XML

    1. Why XML?

    2. Different Faces of XML

    3. Different XML Faces of Office

    4. Opening Office to the World

  2. Chapter 2 The WordprocessingML Vocabulary

    1. Introduction to WordprocessingML

    2. Tips for Learning WordprocessingML

    3. WordprocessingML’s Style of Markup

    4. A Simple Example Revisited

    5. Document Structure and Formatting

    6. Auxiliary Hints in WordprocessingML

    7. More on Styles

  3. Chapter 3 Using WordprocessingML

    1. Endless Possibilities

    2. Creating Word Documents

    3. Extracting Information from Word Documents

    4. Modifying Word Documents

    5. Converting Between WordprocessingML and Other Formats

  4. Chapter 4 Creating XML Templates in Word

    1. Clarifying Use Cases

    2. A Working Example

    3. Word’s Processing Model for Editing XML

    4. The Schema Library

    5. How the onload XSLT Stylesheet Is Selected

    6. Merged XML and WordprocessingML

    7. Attaching Schemas to a Document

    8. Schema-Driven Editing

    9. Schema Validation

    10. Document Protection

    11. XML Save Options

    12. Reviewing the XML-Specific Document Options

    13. Steps to Creating the onload Stylesheet

    14. Deploying the Template

    15. Limitations of Word 2003’s XML Support

  5. Chapter 5 Developing Smart Document Solutions

    1. What’s a Smart Document?

    2. Creating a Smart Document Solution

    3. Coding the Smart Document

    4. Coding in VB.NET

    5. Manifest Files

    6. Other Files

    7. Attaching the Smart Document Expansion Pack

    8. Deploying Your Smart Document Solution

    9. A Few Last Words on Smart Documents

    10. Some Final Thoughts

  6. Chapter 6 Working with XML Data in Excel Spreadsheets

    1. Separating Data and Logic

    2. Loading XML into an Excel Spreadsheet

    3. Editing XML Documents in Excel

    4. Loading and Saving XML Documents from VBA

  7. Chapter 7 Using SpreadsheetML

    1. Saving and Opening XML Spreadsheets

    2. Reading XML Spreadsheets

    3. Extracting Information from XML Spreadsheets

    4. Creating XML Spreadsheets

    5. Editing XML Maps with SpreadsheetML

  8. Chapter 8 Importing and Exporting XML with Microsoft Access

    1. Access XML Expectations

    2. Exporting XML from Access Using the GUI

    3. Importing XML into Access Using the GUI

    4. Automating XML Import and Export

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

    1. What Are Web Services?

    2. The Microsoft Office Web Services Toolkit

    3. Accessing a Simple Web Service from Excel

    4. Accessing More Complex Web Services

    5. Accessing REST Web Services with VBA

    6. Using Web Services in Access

    7. Using Web Services in Word

  10. Chapter 10 Developing InfoPath Solutions

    1. What Is InfoPath?

    2. InfoPath in Context

    3. Components of an InfoPath Solution

    4. A More Complete Example

    5. Using InfoPath Design Mode

  1. Appendix The XML You Need for Office

    1. What Is XML?

    2. Anatomy of an XML Document

  2. Appendix The XSLT You Need for Office

    1. Sorting Out the Acronyms

    2. A Simple Template Approach

    3. A Rule-Based Stylesheet

    4. A More Advanced Example

    5. Conclusion

  3. Appendix The XSD You Need for Office

    1. What Is XSD?

    2. Creating a Simple Schema

    3. Schema Parts

    4. Working with XML Schema

  4. Appendix Using DTDs and RELAX NG Schemas with Office

    1. What Are DTDs?

    2. What Is RELAX NG?

    3. How Do I Convert DTDs and RELAX NG to XSD?

  5. Colophon