VBA Code


XPath Object

Use this object to get or set the data binding used by a list column or range.


Range.XPath.XMLMap
Range.XPath.SetValue
Range.XPath.Clear


ListColumn.XPath


Saving as XML


ThisWorkbook.SaveAs( , xlXMLSpreadsheet) 

Excel 2003 XML Format

Neither VBA code nor embedded objects or charts can be strored in the XMl files in Excel 2002 or 2003


'openxmldeveloper.com


Creating workbooks on the fly


Workbook.XMLMaps.Add 
Workbook.XMLMaps.Namespaces
Workbook.XMLMaps().Delete
Workbook.XMLMaps().Import
Workbook.XMLMaps().Export

Workbook.XMLMaps().DataBinding. 
Workbook.XMLMaps().Schemas(1)

ActiveWorkbook.XmlImport ?? 



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext