Excel & Access No Longer Run macros

[JTBorton]

I'm taking a shot in the dark on this and hoping that someone out there has had this problem before. We use an active-X control in the lab and I wanted to put it on my computer at home so that I can continue working on things. My home computer runs Windows 7 and I recently upgraded to Office 2010. I copied the OCX file into the system32 folder and manually registered it. However, the file would not register and Windows gave me an incompatibility error (turns out the active-x controls from 1998!). So I unregistered the file (just in case, even though it had not registered correctly) and deleted it. But since doing this, Microsoft Excel will not execute any macros. It constantly complains about not being able to find reference libraries. It won't even acknowledge the standard OLE, VBA, and Excel object libraries. Access will run macros, but it will not allow other reference libraries to be added. Does anyone have any clues before I give up and call microsoft tech support?

-Joshua
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]

 

[JTBorton]

On a side note, I had a friend check out the registry and he says there are no problems with the registry.

-Joshua
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]

 

[PHV]

My home computer runs Windows 7 and I recently upgraded to Office 2010
32 or 64 bits ?
I"d have a look here:

http://msdn.microsoft.com/en-us/library/aa384249(VS.85).aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JTBorton]

it's a 64 bit system

-Joshua
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]

 

[PHV]

So, the OCX should go in the SysWOW64 folder, not the system32.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886