3 Replies Latest reply: Mar 21, 2014 8:38 AM by Ravi Kumar RSS

    Export in excel with script module.

    geo gou

      Hello.

       

      I have an issue with an export i'm trying to do and does not work.

      I have a script module in a trigger on post reload action that exports an excel file from a chart.

      The script is :

       

      Sub ExportFiles

      Pathcorp="c:\sales\"

      Set corp = ActiveDocument.GetSheetObject("CH01")

      If store_id="101" then

      corp.ExportBiff Pathcorp & "Sales.xls"

      End if

      End Sub

       

      The store_id is field.


      How can i export only the data for the store "101"

       

      Can anyone help me ?


      Thank you in advance