Excel - XML mapping.

Hi all.

I have a similar issue to a question that can be found in this thread, and it is the closest to answer I've been able to find through using google.

I have the same issue in that I have created my XSD file and pulled it in to Excel. When I manually drag it on to the cell I want it applies the XSD across all columns and rows and I can then export the XML. The problem is a I have no idea how to use this in a macro. I 've looked at the thread above and used the solution and googled ListColumn.XPath.SetValue syntax which the thread opener used as solution but I just can't get it working.

Is someone able to very kindly just show me what the syntax should look like if I'm applying to sheet A Cell B1 and then I can adapt it to use on all sheets in the workbook.

thanks very much.

In case anyone is interested I have the final solution and I have posted it below along with a screenshot of the XML source view in my spreadsheet so if any one has the same issue they can see where the names came from. The issue was I had the names incorrect in the Xpath. The can found in the XML source picture. Just needs to be updated to the names others are using:

Please Login or Register  to view this content.

XML source.png