Export to XML file : Excel XML « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Excel XML

Export to XML file

 

Option Compare Database

Private Sub ExportTestsData()
    Dim objad As AdditionalData
    Set objad = Application.CreateAdditionalData
    objad.Add "Questions"
    objad(Item = "Questions").Add "Answers"
    Application.ExportXML acExportTable, "Tests", "c:\tests4.xml", "c:\tests4.xsd", AdditionalData:=objad
End Sub








Related examples in the same category

1.Get Schema
2.returns a workbook object with the XML data mapped to your spreadsheet:
3.Programmatically Changing XML Map Properties
4.Refresh Your XML Data
5.Creating Your Own XSD
6.Importing Data into an Existing XML Map
7.Exporting to an XML File
8.Leveraging DOM and XPath to Manipulate XML Files
9.Using DOM with ADO to Convert Excel Data to XML
10.Compatibility Mode
11.XML transform