Automation error

Answer

This error is as a result of Microsoft Security update MS12-060  released August 2012

This update has caused a problem with an Office dll file  MSCOMCTL.OCX used by Excel to display controls in forms.

Solution

Re-register the MSCOMCTL.OCX file.

1. Open the Command Prompt (DOS Window) with admin rights (right-click – Run As Administrator)

2. Type the following:

regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX

hit Enter

3. Then Type

regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX

hit Enter

 

64 bit Operating Systems

You will need to subsitute the system32  folder with sysWOW64 in the above commands

i.e.  regsvr32.exe /u C:\Windows\sysWOW64\MSCOMCTL.OCX

      regsvr32.exe C:\Windows\sysWOW64\MSCOMCTL.OCX

 

If this does not work you may have to roll-back to an earlier version of the MSCOMCTL.OCX file. Please follow the steps outlined here:

http://www.fmsinc.com/MicrosoftAccess/Controls/mscomctl/

 

If this still does fix the solution please contact support@merlinxl.com

 Further Information

http://www.fmsinc.com/MicrosoftAccess/Controls/mscomctl/

http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_update/security-update-for-mscomctlocx-kb2597986-ms12-060/6dadedda-7bfa-4569-91d8-a31ebcf6a08a?page=9

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/08/15/quot-unspecified-automation-error-quot-after-applying-ms12-060.aspx