Excel/VBA Automation Errors due to Office Service

Question

After installing all latest windows updates my Excel VBA code is showing an automation error at the very start of the first module. It contains some forms as well as numerous modules of VBA code. However, when removing the forms (and associated code) everything is fine.

The same thing happened about a year ago after some other windows updates. Back then deleting the .exd files did the trick, but the current updates (including Service Pack 3) seem to be different.

What is going on and how can I get the forms to work? All the code is unchanged and has survived all previous windows/office updates. Running Windows 7 (same happening on Vista machine) and Office 2007.

Answer 1

We couldn´t solve the problem by re-registering mscomctl.ocx. But we solved it by removing a "progress bar object form" wich calls mscomctl.ocx... We replaced it with application.statusbar.

Answer 2

I had the same problem. I got an unspecified error opening excel with my Add-In loading. In the past, deleting the *.exd files in C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\ did the trick, but not this time.
When I attempted to open up the forms in my addin, I got a different error and I could not open the forms. I ended up rolling back to last night prior to the update and everything works again.

Answer 3

Same issue here, problem completely solved after registering mscomctl.ocx!

for Windows 7 or 2008 - remember to run cmd.exe "as administrator", and then:

for 32bit Windows systems: regsvr32 c:\windows\system32\mscomctl.ocx

for 64bit Windows systems: regsvr32 c:\windows\syswow64\mscomctl.ocx

Answer 4

Check out http://support.microsoft.com/kb/2687441 for an update that may fix this problem

Answer 5

We have the same problem. In our Add-In, we were able to trace the problem to a declaration of a variable as Excel.Application. The reference to this object is in the Excel.exe file, so it is very unclear as to which files got messed up.

The machines that have this problem were all updated early this morning (15 Aug 2012) with the following updates (sorry for not posting links, as a new user, I'm limited to only two per post):

Security Update for Microsoft Office 2007 suites (KB2596615)

Security Update for Microsoft Office 2007 suites (KB2596754)

Security Update for Microsoft Office 2007 suites (KB2596856)

Security Update for Microsoft Office 2007 suites (KB2687441)

Update for Microsoft Office Outlook 2007 Junk Email Filter (KB2687400)

Windows Malicious Software Removal Tool x64 - August 2012 (KB890830)

At present, we have not found any information on the MSDN site that could clear this up. We're still trying to isolate this down further.

Answer 6

Same issue with VBA for AutoCAD. In my case, registering the new mscomctl.ocx with regsvr32 was enough to fix the issue.