Community discussion forum

MSXML2.DOMDocument not defined

• • Reply

  8 months ago

  by bsmith123

  Ben Smith

  , United States

  Joined 10 months 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
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  8 months ago

  by bsmith123

  Ben Smith

  , United States

  Joined 10 months 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