Topic
  • 3 replies
  • Latest Post - ‏2013-06-18T10:10:49Z by Rizwan.Kaif
VPKR
VPKR
1 Post

Pinned topic How to Close an open excel sheet with TI Process?

‏2012-07-11T20:50:30Z |
Hello,

Please suggest me with an approach to close an open Excel work book with the help of TI process in TM1.
I want to know if there is any approach or possibility to close opened excel from Turbo Integrator process.
If possible, can anyone provide the code?

Thanks in advance.
Updated on 2012-07-15T19:15:53Z at 2012-07-15T19:15:53Z by dusherwo
  • dusherwo
    dusherwo
    73 Posts

    Re: How to Close an open excel sheet with TI Process?

    ‏2012-07-15T19:15:53Z  
    Excel is running on the client.
    TI is running on the server.
    So no, you can't do this.
  • CPM_Anand
    CPM_Anand
    2 Posts

    Re: How to Close an open excel sheet with TI Process?

    ‏2013-06-07T03:12:08Z  

    you should use Excel macro for this instead of TI process as dusherwo explained - it is not possible through TI.

  • Rizwan.Kaif
    Rizwan.Kaif
    197 Posts

    Re: How to Close an open excel sheet with TI Process?

    ‏2013-06-18T10:10:49Z  
    • CPM_Anand
    • ‏2013-06-07T03:12:08Z

    you should use Excel macro for this instead of TI process as dusherwo explained - it is not possible through TI.

    Excel Macro will only work if you are using the sheet in the Excel/Perspectives. But if you are using the same sheet over TM1Web then macros are not supported on the web.

    For TM1Web this is possible by changing the settings of the web.config file