Click here to Skip to main content
15,879,613 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I want to convert an excel sheet to XML using XSD by writing a VB Macro.

This feature is available in Office 2010 where you can map a XSD file in an excel sheet and click on export XML to get an XML file but it works for simple and non-repetitive nested tags.

I have a complex schema definition (XSD) which has repetitive tags under the root tag. In this case, the in-built feature of Office does not work.

Can anyone please let me know how this can be done using the in-built feature ?


Is there any VB macro avaialble for this ?

I googled out but could find C# code only.

Please help !!

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900