All my VBA 2007 Code fails running under Windows 10

razzandy

Active Member
Joined
Jun 26, 2002
Messages
390
Office Version
  1. 2007
Platform
  1. Windows
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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.
 
Upvote 0
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
 
Upvote 0
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

:)
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,927
Members
448,533
Latest member
thietbibeboiwasaco

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