Hi,
I would like to be able to create XML output from data entered on an excel spreedsheet based on my own xsd. I am using Office 2k. I have tried using the XML data mapper in Office 2003 however it does not support Lists of Lists in an XML file which I have defined in my schema. I would appriciate it if someone could steer me in the right as to the best way to go about this or point me in the right direction where I can get more info.
Thanks,
Adrian.
Generate XML from Excel Data
Hot Topic
- Access data source question
- experiences with MS software testing?
- Extracting email addresses (from column), date and subject line from Outlook to excel
- Microsoft Partnering and License
- work localy with database
- Does the VBA save word as XML???
- Emailing sheet with Excel macro
- Absolute Links in Excel
- How Can I create an UDF I can use in a cell?
- Emailing from an Access form.
Microsoft ISV
- Future of VBA (and VBScript)?
- Defining a range according to the number of responses
- vba access updating a record
- Someone mind helping me with Error 426
- Using a Macro (VBA) to select a variable number of rows
- Opening a Word file from a macro in Excel
- MultiPage problem!
- check if workbook is open
- Disabling enter and mouse click PPT navigation
- Problem With Code That Writes a Change To Itself
Generate XML from Excel Data
MarnixG
Per our support engineer:
There are some work arounds.
http://msdn.microsoft.com/library/en-us/odc_xl2003_ta/html/odc_xl_Excel2003XMLIntro.asp
1. http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_xl2003_ta/html/odc_XMLLists.asp
2. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dno2k3ta/html/odc_OF_WordXMSchemas.asp
3. http://elevenwolf.cnblogs.com/archive/2004/08/21/35324.aspx (Chinese)
4. http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_xl2003_ta/html/OfficeExcelXMLToolAddin.asp
5. http://msdn.microsoft.com/library/en-us/odc_xl2003_ta/html/odc_xl_Excel2003XMLIntro.asp
Regards, Xiang
-brenda (ISV Buddy Team)