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.

“Owning a computer without programming is like having a kitchen and using only the microwave oven” - Charles Petzold