Microsoft xml v6.0 not working in excel 2013

[moe0303]

Related thread: http://www.mrexcel.com/forum/excel-questions/783092-new-computer-3.html

Hello,

I have a weird issue. I have spreadsheet with some macros that parse xml files and presents the data in relevant columns. The code was written in excel 2010 and works fine in that environment. When I try opening the file in 2013, I get a "User defined type not defined" error. If I change the reference to xml v3.0 instead of v6.0 it gets a little farther but eventually fails as well.

The code highlighted for the above error is:

Dim xmlFile As New MSXML2.DOMDocument

I tried changing DOMDocument to DOMDocument60, but also got errors (documented in the related thread). Internet searches have said something about they way DOMDocuments are exposed in 2013 is different. I'm not sure what any of that means. Have any of you guys ever heard of this problem?

-Moe

 

[chicagocomputerclasses]

Have you tried to simply download and install https://www.microsoft.com/en-us/download/details.aspx?id=3988 ?

 

[moe0303]

I'm pretty sure I already have it. Microsoft XML, v6.0 is selected as a reference.

 

[Kenneth Hobson]

Works for me in win7. Are you using win10?

 

[moe0303]

Yes, I am using windows 10.

 

[chicagocomputerclasses]

try this without new .

Dim xmlFile As MSXML2.XMLHTTP60
Set xmlFile = CreateObject("MSXML2.XMLHTTP.6.0")


or

Dim xmlFile As MSXML2.DOMDocument60
Set xmlFile = New MSXML2.DOMDocument60

 

[Kenneth Hobson]

or maybe,

Dim xmlFile As MSXML2.DOMDocument
set xmlFile = New MSXML2.DOMDocument

 

[moe0303]

try this without new .

Dim xmlFile As MSXML2.XMLHTTP60
Set xmlFile = CreateObject("MSXML2.XMLHTTP.6.0")

ended up with this error: "Object doesn't support this property or method" for

xmlFile.async = False

or

Dim xmlFile As MSXML2.DOMDocument60
Set xmlFile = New MSXML2.DOMDocument60

Resulted with Run-time error '91': Object variable or With block variable not set at the following line:

STIG = xmlFile.selectSingleNode("Benchmark").selectSingleNode("title").nodeTypedValue

 

[moe0303]

or maybe,

Dim xmlFile As MSXML2.DOMDocument
set xmlFile = New MSXML2.DOMDocument

Fails at the

Dim xmlFile As MSXML2.DOMDocument

with User-defined type not defined.

 

[chicagocomputerclasses]

I think you should declare async as an argument in your .open method, rather than s separate line.