Page 1 of 1
TM1_API2HAN Lib "tm1.xll" not loaded
Posted: Fri Jul 25, 2014 6:05 am
by macsir
Hi, There
I am trying to use the following code
Code: Select all
Declare Function TM1_API2HAN Lib "tm1.xll" () As Long
in the module of my VS2010 VB.net application.
Compiling is successful but when executing to
it is saying tm1.xll can't be loaded.
This code is originally used in VBA and can be run successfully. Not sure how I can convert it into VB.net to load and use it correctly?
Re: TM1_API2HAN Lib "tm1.xll" not loaded
Posted: Fri Jul 25, 2014 6:09 am
by Alan Kirk
macsir wrote:Hi, There
I am trying to use the following code
Code: Select all
Declare Function TM1_API2HAN Lib "tm1.xll" () As Long
in the module of my VS2010 VB.net application.
Compiling is successful but when executing to
it is saying tm1.xll can't be loaded.
This code is originally used in VBA and can be run successfully. Not sure how I can convert it into VB.net to load and use it correctly?
You can't. TM1_API2HAN is
ONLY for use with the Excel add-in and piggy-backs off the login that the user has made through the Excel interface. For VB.Net you use the
full method for connecting to the server.
Re: TM1_API2HAN Lib "tm1.xll" not loaded
Posted: Fri May 18, 2018 1:38 pm
by kavitha2002
Hi Alan,
I am new to TM1 and IBM cognos.
I am also facing the same issue with "TM1_API2HAN Lib "tm1.xll" not loaded". I am using vb.net project with excel integrated and application starting with tm1p.xla add-in.
Using Tm1 CAM security SSO enabled environment. I want to connect to TM1 perspectives using N_CONNECT_CAM. Previously using N_CONNECT for tm1 IntegratedSecuritymode=1
I have referred the link below from IBM, and converted the vba to vb.net code. So facing the tm1.xll not loaded problem.
http://www-01.ibm.com/support/docview.w ... wg21959177
Is there any other way to open TM1 perspectives from VB.net app. Kindly suggest me. Thanks