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

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
    72 Posts
    ACCEPTED ANSWER

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

    ‏2012-07-15T19:15:53Z  in response to VPKR
    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
    ACCEPTED ANSWER

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

    ‏2013-06-07T03:12:08Z  in response to VPKR

    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
      ACCEPTED ANSWER

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

      ‏2013-06-18T10:10:49Z  in response to CPM_Anand

      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