Members

Technology Zones

Articles

Hosted By

MaximumASP

Info

MSXML2.DOMDocument not defined

Last post 02-24-2008 1:05 PM by John_Fairley. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-23-2008 10:58 PM

    • John_Fairley
    • Not Ranked
    • Joined on 02-23-2008
    • United Kingdom
    • New Member
    • Points 10

    MSXML2.DOMDocument not defined

    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

     

    • Post Points: 5
  • 02-24-2008 1:05 PM In reply to

    • John_Fairley
    • Not Ranked
    • Joined on 02-23-2008
    • United Kingdom
    • New Member
    • Points 10

    Re: MSXML2.DOMDocument not defined

     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 Points: 5
Page 1 of 1 (2 items)