"Unspecified Automation Error" when Opening Excel using BAM Addin.
Fixit Available
There is a fixit available for this problem:
Office 2010 w SP1 - http://support.microsoft.com/kb/2597986
Office 2007 w SP2 or SP3 - http://support.microsoft.com/kb/2687441
Office 2003 w SP3 or Office 2003 Web Components w SP3 - http://support.microsoft.com/kb/2687323
Steps to fix the problem manually
The manual fix for this problem is to re-register MSCOMCTL.OCX. To do this, follow these steps:
1. Open an administrative-level command prompt. The command prompt MUST be on the administrative level for this to work. Click START, and type RUN in the run command line. On Windows Vista and Windows 7 you will see CMD.EXE appear in the quick search list. Right click CMD.EXE and left click Run As Administrator. A black command prompt opens. On Windows XP, there is no built-in run-as-admin, but you can use the run as menu option (or runas command line) to execute an admin command from a Limited User Account.
2. If on a 64-bit machine, type the following:
regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX
Hit ENTER
then type
regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX
If on a 32-bit machine, type the following:
regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX
Hit ENTER
then type
regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX
Your Excel BAM Addin should work again after doing this.
FYI,
