"tm1p.xla" excel addin is not installing for all users.
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
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.