ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting / Saving as XML (https://www.excelbanter.com/excel-discussion-misc-queries/207254-exporting-saving-xml.html)

WalkToFreedom

Exporting / Saving as XML
 
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

Exporting / Saving as XML
 

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" wrote:

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.


WalkToFreedom

Exporting / Saving as XML
 


"Brent E" wrote:


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" wrote:

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.


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

WalkToFreedom

Exporting / Saving as XML
 


"WalkToFreedom" wrote:

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/n.../article_8.htm



All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com