I have some code on my web site that will create an XML file containing cell
values and information. The hierarchy in the schema is

Areas - Area - Cells - Cell == Address, SheetName, Value, Displayed
Value, Number Format.

Download the schema and the workbook that creates the DOM and saves the XML
file in the zip file

http://www.cpearson.com/Zips/ExceTtoXML.zip

You can probably modify the schema and VBA code to meet your needs.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)



wrote in message
oups.com...
I have an excel document that I would like to export to xml. I have
been able to create a schema and map each column in excel to the
proper xml node. The question I am having is, instead of mapping to
columns, is there a way to map individual cells? Or even specific
text within a cell?