Question

Q: 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.

Answer

A:

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.

Did this solve your problem?

Sorry this didn't help.

43 people were helped by this reply



 
Question Info

Views: 17,526 Last updated: June 18, 2018 Applies to: