MSXML2.DOMDocument not defined

  • 6 years ago

    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

     

  • 6 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!

    John 

     

Post a reply

Enter your message below

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

Contribute

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.

“Walking on water and developing software from a specification are easy if both are frozen.” - Edward V Berard