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….
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:
Step 3: Open the ‘References’ toolbox
Step 4: Unselect MSXML 6.0
Step 5: Select MSXML 3.0 or 5.0
Step 6: Click ‘OK’ and run your macro again. Your XML import should work fine.