Scripting Question

"tm1p.xla" excel addin is not installing for all users.

01/27/2014 5143 views

I am working on IBM Cognos TM1 9.5. There is an excel addin which installs to C:\Program Files\Cognos\TM1\bin\tm1p.xla".

After installing the application, addins reflect in admin but not in test user. I tried with the below script to add the addins for users but it corrupts the excel and i gives a error on launching the application excel shortcut.

On Error Resume Next 
Dim oXL
Dim oAddin
Set oXL = CreateObject("Excel.Application")
Set oAddin = oXL.AddIns.Add("C:\Program Files\Cognos\TM1\bin\tm1p.xla", True)
oAddin.Installed = True
Set oAddin = Nothing 
Set oXL = Nothing 

Is there any method to add the addins for all users.

I even tried to copy the .xla file to XLStart folder But it throws the ocx and dll error even after registering the both the file manually.

0 Comments   [ + ] Show comments


All Answers


If you're deploying the package automatically i.e. through SCCM/Radia/whatever, you'll be using the local System account. Add-ins get added on a per-user basis so the above will be adding it for that account. Not a lot of use.

You'll need to build a feature tree that can trigger self-healing. Search for John McFadyen's excellent blog about self-healing.

Additionally, the script above is very basic, with zero error-trapping and many assumptions about things like paths. Search AppDeploy for the Excel add-in script by 'Captain Planet'. It is pretty much bullet-proof.

Answered 01/28/2014 by: VBScab
Red Belt

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ