Today Thursday 16 August 2010 I'm getting inexplicable automation errors (1004) in my mission-critical .xlsm (and in all my macro-enabled Word and Excel documents), the code of which has remained unchanged and has worked perfectly for months. All my macro settings are as they should be, needless to say.

The only change has been the 20 Windows 7 updates last night (15 August) when I shut down my computer.

Windows 7, Office 2010



Can an MVP help please? This is very urgent.

Thank you in advance

Richard

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

Go figure!