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")
oXL.Workbooks.Add
Set oAddin = oXL.AddIns.Add("C:\Program Files\Cognos\TM1\bin\tm1p.xla", True)
oAddin.Installed = True
oXL.Quit
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

Comments

Please log in to comment

Answers

0

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

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share