We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

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)