automation error

[yuval]

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

[moby91]

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

[yuval]

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

[tcasey]

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

[tcasey]

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