I have been working with Xml files in Excel for some time now, and thought it is time to share some observations.
Create Xml from Schema
2013/10/04 by
In this post I describe a tool to create an Xml file from a schema (Xsd) using VBA and the DOM and SOM objects of the Microsoft XML library MSXML version 6.
Get XPaths from workbook – update
2013/09/03 by
In Get XPath objects from Excel workbook I described a method to retrieve all mapped XPaths from a workbook. In this post I describe another method, using the Worksheet.XmlMapQuery function. It’s simpler, and faster.
Sepa Direct Debits: from Excel to Pain
2013/06/18 by
Europe is preparing for SEPA, the Single Euro Payments Area. One of the SEPA goals is to replace all national direct debit standards by one XML based SEPA standard by 1 February 2014. This article shows how to create such an Xml file from Excel, without scripting.
Get XPath objects from Excel workbook
2013/06/06 by
When working with XML enabled workbooks the relevant objects and properties are easy to retrieve. Unfortunately a workbook has no built-in collection of XPath objects. How can we get a list of all XPath objects in a workbook?
Recent comments