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

    Export in excel with script module.

    gou geo



      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


      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