Get out clean XML data

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.

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.

In article <[email protected]>,
"Diane" <[email protected]> wrote:

> 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.