This entry was posted on Monday, May 28th, 2012 at 2:24 pm and is filed under Tech Stuff. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.
If you are running on a 64bit windows 7 system and have a VBA script that creates a COM/ActiveX/OLE component which fails with an error message like:
‘ActiveX component can’t create object’
Even though you know the component is registered and that you are using the correct progId etc, then it may be failing because the COM component in question is 32 bit and by default Windows7 runs the 64bit scripting engine.
If this is the case then you can get around the problem by explicitly using the 32 bit scripting environment which is most likely located here:
So to run example.vbs in the 32bit environment use the following:
Hopefully you 32bit component will now load… mine did