How can i call the TI proccess while closing excel?
can i do it at marco?
Call TI proccess while closing excel
-
kennyyeung
- Posts: 19
- Joined: Fri May 15, 2009 12:44 pm
- Version: 9.4 MRC
- Excel Version: 2000
Re: Call TI proccess while closing excel
Why not schedule a chore?
-
kennyyeung
- Posts: 19
- Joined: Fri May 15, 2009 12:44 pm
- Version: 9.4 MRC
- Excel Version: 2000
Re: Call TI proccess while closing excel
It's a great idea! Thank !
For curious . It that a way to do that kind of action?
For curious . It that a way to do that kind of action?
-
Alan Kirk
- Site Admin
- Posts: 6644
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Call TI proccess while closing excel
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.)kennyyeung wrote:It's a great idea! Thank !
For curious . It that a way to do that kind of action?
However par3 is right; if you can schedule the chore it'll be much, MUCH easier.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.