new computer

fastbuck

Board Regular
Joined
Apr 22, 2014
Messages
144
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
 
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:
Code:
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
 
Upvote 0
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:

Code:
sSTIG = xmlFile.selectSingleNode("Benchmark").selectSingleNode("title").nodeTypedValue
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,926
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top