TM1 Forum

How can i call the TI proccess while closing excel?
can i do it at marco?

Why not schedule a chore?

It's a great idea! Thank !
For curious . It that a way to do that kind of action?

kennyyeung wrote:It's a great idea! Thank !
For curious . It that a way to do that kind of action?

You could write VBA code which calls the TM1 API, and have it run on the Workbook_BeforeClose event of a workbook which is closed when Excel is. (Personal.xls comes to mind, though any hidden workbook which is loaded with Excel would do.)

However par3 is right; if you can schedule the chore it'll be much, MUCH easier.