MSXML2.DOMDocument not defined

  • 7 years ago

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

    I found an article ( 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? 




  • 7 years ago

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

    Sorry if I've wasted any brainpower!



Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.” - Antoine de Saint Exupéry