VB6 Control Security Update causes control to fail (updated)

By Laura Holzwarth

A new security update (MS12-027)  released, April 10 has been released that affects MSCOMCTL.OCX, which means this not only affects Excel, but can affect all of the Office applications including Word and Power Point.

When you enable macros in an Excel 2003, 2007, 2010 you will receive the following error messages;  

followed by

or

Fixit is now live

The FixIt for this issue is now live.

https://support.microsoft.com/kb/2703186

However, you may also follow the steps to manually fix this problem after the update by following the directions below.

Steps to follow after update

After installing the update you may need to follow the following steps to get rid of the error message listed above.

You install this security update on a computer that has a third-party software solution installed. The software solution is based on Microsoft Visual Basic for Applications (VBA). The software solution creates an instance of the control directly through Microsoft Office. In this scenario, the control may not load in your solution.

To resolve this issue, you must delete the cached versions of the control type libraries (extender files) on the client computer. To do this, you must search your hard disk for files that have the ".exd" file name extension and delete all the .exd files that you find. These .exd files will be re-created automatically when you use the new controls the next time that you use VBA. These extender files will be under the user's profile and may also be in other locations, such as the following:

%appdata%\Microsoft\forms

%temp%\Excel8.0

%temp%\VBE

Scripting solution

Because this problem may affect more than one machine, it is also possible to create a scripting solution to delete the EXD files and run the script as part of the logon process using a policy. The script you would need should contain the following lines:

del %temp%\vbe\*.exd

del %temp%\excel8.0\*.exd

del %appdata%\microsoft\forms\*.exd

del %appdata%\microsoft\local\*.exd

del %appdata%\Roaming\microsoft\forms\*.exd

del %temp%\word8.0\*.exd

del %temp%\ PPT11.0\*.exd

For more information

Please see the article that applies to your version of Office.

2597112 MS12-027: Description of the security update for Microsoft Office 2003 Service Pack 3: April 10, 2012 (https://support.microsoft.com/kb/2597112)

2598041 MS12-027: Description of the security update for 2007 Microsoft Office system: April 10, 2012 (https://support.microsoft.com/kb/2598041)

2598039 MS12-027: Description of the security update for Office 2010: April 10, 2012 (https://support.microsoft.com/kb/2598039)