Summary

In this chapter, I covered the different ways that you can use Excel to work with XML content. We opened an existing XML document in Excel in three different ways: as a list, as a read-only workbook, and using the XML Source pane. We generated XML content from Excel using the Save As and Export commands. Throughout the chapter, we worked with XML maps that provided information to Excel about the XML structures within a document. In the last exercise, we included content from an Excel document within a Flash catalog application.

You can find out more about Excel XML at the Microsoft website. You might find it useful to complete the online training at http://office.microsoft.com/training/training.aspx?AssetID=RC011310531033. You can also find a quick reference card at http://office.microsoft.com/training/ Training.aspx?AssetID=RP011310601033&CTT=6&Origin=RC011310531033. The Office XML Developer Center lists resources, including articles and downloads, and you can find it at www.msdn.microsoft.com/ zoffice/understanding/xmloffice/default.aspx.

Access 2003 offers the simplest XML functionality of all the Office packages. One difference is that it doesnt have its own XML vocabulary. You can find out more about Access 2003 and XML in the next chapter.