new computer

[fastbuck]

Hi out there. I've just bought a new compute with windows 8 and office 2013. I'm trying to use a spreadsheet with macros that has worked fine on my old computer with office 2007. It comes up with an error that says 'Compile Error. User-defined type not defined' and it highlights this in one of the macros 'xmldoc As MSXML2.DOMDocument''
Can anyone help with this problem - it would be much appreciated.
Thanks
Narelle

 

[moe0303]

I have the same issue. While switching to v3 got me a little further, it failed with other macros in the file. I changed all instances of MSXML2.DOMDocument to MSXML2.DOMDocument60 and got even further, but it failed here:

Set xmlFile = CreateObject("MSXML2.DOMDocument60")

"Run-time error '429': ActiveX component can't create object"

The following is a link with some info on the problem. Like fastbuck, I don't quite understand what I'm working with here. Any ideas? I can open a new thread if needed, but I figured it was related to this.

https://social.technet.microsoft.co...2b76e3f7f/microsoft-xml-v60-msxml6dll-and-vba

 

[moe0303]

I changed the code above from "MSXML2.DOMDocument60" to "MSXML2.DOMDocument.6.0" and failed a little farther down the line with a "Run-time error '91': Object variable or With block variable not set" at this line of code:

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

 

[moe0303]

Anybody else have this issue?