Inexplicable automation errors in Word and Excel

[RichardP]

Last night (15 August 2010) there were 20 Windows 7 updates. Since then all my macro-enabled documents in Word and Excel report automation errors (1004), even though I haven't changed the code for months!


Any ideas? Can an MVP help please? This is very urgent

[RichardP]

After some online research, I solved this by (re?)registering mscomctl.ocx
regsvr32 C:\Windows\SysWOW64\MSCOMCTL.OCX

Go figure!

[Venky62]

Interesting. Could you explain how you did this, in case some of us also run into this problem?

[RichardP]

http://stackoverflow.com/questions/1...aused-by-forms

I simply registered the .ocx as I said in my previous post, i.e.
Start > Run
then regsvr32 C:\Windows\SysWOW64\MSCOMCTL.OCX

This is specific to 64-bit Windows 7 (running Office in 32-bit mode, the most common scenario)
For 32-bit WIndows, the equivalent would be:
regsvr32 c:\windows\system32\mscomctl.ocx

For some inexplicable reason, the Windows updates on Wednesday night (15/08/2012) must have unregistered this file

[macropod]

Curious. I have the same setup (64-bit OS and 32-bit Office) and have encountered no problems.