Get Schema : Excel XML « Excel « VBA / Excel / Access / Word






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

Get Schema

 
     Sub GetSchema()
         Dim MySchema As String
         'Get the schema
         MySchema = ActiveWorkbook.XmlMaps("EmployeeSales_Map").Schemas(1).XML
         Open "C:\MySchema.xsd" For Output As #1
         Print #1, MySchema
         Close #1
     End Sub








Related examples in the same category

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