TM1 Forum

Hello All,

Version TM 1 :10.1.1
Excel :2007
I am trying to perform an activity to run a process using VBA code to execute TM1 process on the server

as i have parameters which i need to pick up from an excel worksheet.
i am using following syntax to execute
sTIRun = RunTIProcess("Tm1Server", "test_ug", Spar1, Spar2)

i get a compile Error: sub or Function not defined. and it gets highlighted at RunTIProcess.

1. Am I Missing anything?
2. I checked the Tm1p.xla is added in add-ins. and server is connected.

Firefly007 wrote:Hello All,

Version TM 1 :10.1.1
Excel :2007
I am trying to perform an activity to run a process using VBA code to execute TM1 process on the server

as i have parameters which i need to pick up from an excel worksheet.
i am using following syntax to execute
sTIRun = RunTIProcess("Tm1Server", "test_ug", Spar1, Spar2)

i get a compile Error: sub or Function not defined. and it gets highlighted at RunTIProcess.

1. Am I Missing anything?
2. I checked the Tm1p.xla is added in add-ins. and server is connected.

Yes, you are indeed missing one key thing... the TM1 Add-in does not have a RunTIProcess function. Why not? Ask IBM, though they'll probably tell you that their TM1RunTI.exe external executable makes it unnecessary... unless of course you're a Cognos Express user, in which case Big Blue Says No.

However, it appears that what you picked up is a fragment of code that shows you how to execute the RunTIProcess function that Martin Ryan added to the TM1 Tools add-in. You would need to have that loaded and have a reference to the TM1 Tools project to use it the way you've described. I've added instructions on how to do that to the Help File that you can download with the add-in.

Thank you Kirk!

I see it is a customised function developed by you in the .xla file which you gave me. It was very helpful to understand more indetail how the API's called.