Export Excel Data to xml

[DairylandDan]

The company for which I work utlizes a 12 sheet Excel workbook full of formulas to alter data entered on one sheet and fill in cells on other sheets. This is for reporting to the State DNR. Now, the DNR wants the data from this Excel document dumped into an xml document they provide. But, whenever I try to do data/xml/export to xml (from the Excel document) I get the error: "Cannot save or export XML data. The xml maps in this workbook are not exportable."

I don't have an xsd (I'm trying to let Excel infer one) or a dtd.

Any tips or ideas?


dld

 

[xlhelp]

Pls look at this and see if you get any help:

http://office.microsoft.com/en-us/excel/HP010246251033.aspx

Vita Brevis