Hi All,
I have a situation here, I am trying to call TM1p.xla file from VBA Macro, so that I can use "N_Connect" function to connect to TM1 Instances.
I am doing all of these on following System
User: Administrator
OS: Windows 2012 R2 Standard Edition 64 Bit
TM1: 10.2.2 FixPack 5 64Bit and 32 Bit Perspective.
Excel: 2007 with SP3.
Problem Statement:
I use following command in Workbook_Open() and my workbook is called from a VBS script which runs out of command prompt.
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
Application.MultiThreadedCalculation.Enabled = True
Workbooks.Open ("C:\Program Files (x86)\ibm\cognos\tm1\bin\tm1p.xla")
msg = Application.Run("n_connect", "TM1InstanceName", "UID", "PWD")
End Sub
below error comes on line "application.run"
The problem is I am able to execute the same code on my laptop which runs on Windows XP Professional Edition and TM1 10.1
This also works on other System which runs on Windows 2008 R2 Edition running TM1 10.1.
But somehow, this doesnt work on our newBox which runs on Win2012R2 Std edition.
- I have added TM1p.xla into Add-Ins.
- I have also added TM1 Bin directory into Trusted Location in Excel Settings.
- My macro setting is "Enable all macros" with trust Access to VBA project object model.
I tried almost everything that I had to and still trying. From my analysis I feel that, somehow excel is blocking the functions of TM1p.xla due to some security reasons.
I have been experimenting all of these things with Administrator credentials.
If you guys could please take a look to this issue and provide any resolution to this then it will be grateful.
Thanks
Cipher!