MSXML2.DOMDocument not defined

  • 8 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? 




  • 8 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.

“A computer lets you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila” - Mitch Ratcliffe