Programmatically Changing XML Map Properties : Excel XML « Excel « VBA / Excel / Access / Word






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

Programmatically Changing XML Map Properties

 
     Sub ChangeXmlMapProperties()
         With ActiveWorkbook.XmlMaps("EmployeeSales_Map")
             .name = "New_Name"
             .ShowImportExportValidationErrors = False
             .SaveDataSourceDefinition = True
             .AdjustColumnWidth = True
             .PreserveColumnFilter = True
             .PreserveNumberFormatting = True
             .AppendOnImport = False
         End With
         ThisWorkbook.XmlMaps(1).name = "EmployeeSales_Map"
     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.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