I'm learning XML and trying to develop an XML file from Excel.

I found an article (http://msdn2.microsoft.com/en-us/library/aa203742.aspx) by Gundorov and Hamilton about Automating the XML Data Mapping Process in Excel 2003 on MSDN very helpful.  However when I came to run their ProcessSheet macro I got an error on MSXML2.DOMDocument as User defined type not defined.

 I had already installed MSXML.2, MSXML 3 and MSXML.6, what else should I do?

Can you please advise? 

 
Thanks,

 John

 

 Apologies, I've discovered the machine didn't have the VBA Reference to Microsoft XML enabled.

 
Sorry if I've wasted any brainpower!

John