Connect to TM1 server using VBA

[Manojav]

Hi ,


I need to connect to TM1 server using VBA. I tried using "N_Connect" and it is failed with the error "LoginFailed:SystemServerCAMSecurityRequired"


I have some TM1 functions and expressions in the worksheet which will get executed and populate the data once connected. I need to achieve this by making a connection to TM1 server using VBA. Once the data is populated, need to disconnect as well.


I am very new to this and any help is appreciated


Thank you !!


Thanks & Regards,
Manoj

 

[mole999]

Read here > https://www.connectionstrings.com/excel/ it might help

 

[Manojav]

Read here > https://www.connectionstrings.com/excel/ it might help

Hi ,

Thank you for the response. But unfortunately, I can't find what i am looking for in that link.

Hope somebody knows the way still

Thanks,
Manoj