Exporting / Saving as XML

[WalkToFreedom]

When I saves as/export as XML it only saves one row as xml. How do
export/save all the rows as plain xml? I can't seem to assign the xml
mappings to more than one cell?

Thanks.

 

[Brent E]

I don't know if these will provide what you're looking for but may get u on
the right track.

desribes some Excel and Access XML and provides a VBA module to convert an
Excel file.
http://www.meadinkent.co.uk/xl_xml1.htm

and free web tutorials at:
http://www.w3schools.com/

 

[WalkToFreedom]

I don't know if these will provide what you're looking for but may get u on
the right track.

desribes some Excel and Access XML and provides a VBA module to convert an
Excel file.
http://www.meadinkent.co.uk/xl_xml1.htm

and free web tutorials at:
http://www.w3schools.com/

Thanks for your reply, but office 2003 does it natively I shouldn't have to
use a macro.

 

[WalkToFreedom]

When I saves as/export as XML it only saves one row as xml. How do
export/save all the rows as plain xml? I can't seem to assign the xml
mappings to more than one cell?

Thanks.

The answer is to use a schema that contains repeating information. I found
this link:

http://www32.brinkster.com/srisamp/netArticles/article_8.htm