So you’ve created a magnificent automated report in Excel that just pulls the data in via XML and your customers go “wow!” when they see how easily your reports work, until….

Error: User-defined type not defined

This seams to be because a newer version of MSXML (v6.0 in this case) was installed. To get your document to work as expected again, you need to select the proper reference libraries for MSXML. In my case I needed to change it back to MSXML v3.0 to get it to work.

To do this:
Step 1: Press ALT+F11 to open the Visual Basic editor

Step 2: If you haven’t done so already, stop/reset the current operation that is running:

Stop the running operation

Step 3: Open the ‘References’ toolbox

Open ‘Tools->References’

Step 4: Unselect MSXML 6.0

Unselect Microsoft XML, v6.0

Step 5: Select MSXML 3.0 or 5.0

Select MSXML 3.0 or 5.0

Step 6: Click ‘OK’ and run your macro again. Your XML import should work fine.