TM1 Forum

Hi,

Im trying to open tm1p.xla as usual and "automation error" message pop up, tried to use ibm solutions like register mscomctl.ocx

but with no success, does anyone know this error?

thanks

What happens when you execute the steps outlined by the IBM Technote 1608271 after you started the DOS Shell (cmd.exe) using the "Run as admin" option ?

http://www-01.ibm.com/support/docview.w ... wg21608271
Unable to launch TM1 Perspectives: Microsoft Visual Basic Automation Error Unspecified Error

it works, I guess I tried to register the file in the wrong path

I'm getting this same error on my work laptop (but not on my work desktop, nor is anybody else at work getting this error).

I followed the steps at below link for both Excel 2003 and 2007 (I run both on my work laptop and desktop):

http://www-01.ibm.com/support/docview.w ... wg21438688

These steps complete successfully, but on reboot the problem still persists.

Also on the laptop, Architect won't run normally - it crashes on displaying cube views.

I've uninstalled/reinstalled TM1 on the laptop and it still persists.

Both desktop & laptop run Windows XP Pro Version 2002 SP3

Anybody else having this problem/found a solution?

Thanks,

...Tom

Update : Solution Found...

This morning I got the error on my desktop as well after Windows Updates were automatically installed on my computer. Through the advice of our tech guy I followed the instructions for Windows 2007 and Excel 2007 (even though I am running Windows XP and Excel 2003/2007):

Per IBM Tech Note: http://www-01.ibm.com/support/docview.w ... wg21608271

Resolving the problem

Unregister and re-register the mscomctl.ocx file.


For 64 bit machines:

regsvr32 /u C:\Windows\SysWOW64\mscomctl.ocx

regsvr32 C:\Windows\SysWOW64\mscomctl.ocx


For 32 bit machines:

regsvr32 /u C:\Windows\System32\mscomctl.ocx

regsvr32 C:\Windows\System32\mscomctl.ocx

Following the 32-bit instructions put me back in business.

Regards,

...Tom