Cannot create xml table in Excel 2010 with 2003 xml tools add-in

I downloaded and installed the Excel xml tools add-in according to the instructions inhttp://office.microsoft.com/en-us/excel-help/create-an-xml-data-file-and-xml-schema-file-from-worksheet-data-HA010342365.aspx andhttp://www.microsoft.com/downloads/en/details.aspx?FamilyId=72852247-6AFD-425C-83B1-1F94E4AC2775&displaylang=en.  When I run the add-in by trying to convert a range to an xml table, I get the following message:"compile error: user-defined type not defined", and the process stops.

I need to do this to be able to save the resulting xml table as an xml file and in turn import it into another application.  Please help, I desperately need this to work.

 

Question Info


Last updated November 20, 2018 Views 17,951 Applies to:
Answer
When the error is displayed msxml2.DOMDocument50 variable, you have to do is delete the number 50 and leave only msxml2.DOMDocument. Press the F5 key to continue exploring the compiler errors and each occurrence of this variable will delete the number. Then show the table you need to export to XML.

43 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.