I wrote a VBA macro to download and parse an XML file. This exact code worked fine, but now it no longer works. I tested it on two different computers with a 64-bit version of Excel 2013. The code in which it does not work is below:
Public Sub RunClashImport()
'This subroutine will import an XML clash report, parse it, and write it to our workbook
Dim iRow As Integer
'Get XML file
Dim xmlFile As MSXML2.DOMDocument60
Set xmlFile = New MSXML2.DOMDocument60
The code is saved if I comment on the Set command. It does not throw errors, completely destroys Excel. There is a macro in the code above, there is no code in front of it. I set the link to v6.0 from MSXML
source
share