Adding a Schema to a Workbook : Worksheet Export Import « Excel « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Excel
3. Worksheet Export Import

Adding a Schema to a Workbook

 
Sub ImportXMLSchema()
    Dim xmMap As XmlMap
    Application.DisplayAlerts = False
    Set xmMap = ActiveWorkbook.XmlMaps.add("C:\invoice.xml", "Invoice")
    Application.DisplayAlerts = True
    xmMap.AdjustColumnWidth = False
    xmMap.PreserveNumberFormatting = True

    Set xmMap = Nothing
End Sub

 

Related examples in the same category