Get out clean XML data

D

Diane

I would like to get data out of Excel and into an XML document.
How do I go about setting up Excel so that, for example, cell A5 will be
exported as <Employee Name>Value of cell A5</Employee Name> and cell A6 will
be <Date>4/15/05</Date> etc etc.
 
J

JE McGimpsey

I think you'll have to write some VBA to do that, or use XSLT. I don't
know how XL could know that A5 was an Employee Name.
 
Top