All my VBA 2007 Code fails running under Windows 10

[razzandy]

I upgraded to windows 10 today and I thought I may like it until I tried running my programmes coded in Excel 2007 VBA. First of all I found I could not save a file to C:\ for some reason VBA was trying to add a random number after c:\ After changing the path to users\documents I then tried running my code which uses Microsoft XML Ver 6. My code fails as soon as I try to run at the following line:

Dim ReqHTTP As New XMLHTTP

The error is a Compile Error: User-defined type not defined

Has anybody any idea why this before I revert back to windows 7?

Thanks in advance

 

[V_Malkoti]

Check you library references (Tools -> References). It is likely that Windows upgrade unregistered (and then re-registered) them or moved those libraries to a different location. I think that you need "Microsoft XML, vx.0" to be selected in there.

 

[razzandy]

Check you library references (Tools -> References). It is likely that Windows upgrade unregistered (and then re-registered) them or moved those libraries to a different location. I think that you need "Microsoft XML, vx.0" to be selected in there.

thanks for your input

Thanks for that but I have double checked the references are still there and they where. I am now deselecting saving then will reselect to see if that fixes it.

Well be back in a mo

 

[razzandy]

Think I've sorted it V_Malkoti

XML Ver 6 doesn't work Ver 3 or 5 works ok so I have gone with Ver 5.

Thanks for your help