Back to discussion

MSXML2.DOMDocument not defined

Last post was 24 Feb 2008 at 13:05
xml MacKinney, United States
  • 13 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

     

    Report abuse
  • 13 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 

     

    Report abuse

Post a reply

Enter your message below

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

XML forum discussion

XML tutorials

Quick links

Recent activity

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!

Web Development

Developer Jobs

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.

Cancel
“Brevity is the soul of wit” - Shakespeare