21 Replies Latest reply: Feb 20, 2012 1:06 AM by Ashok Chandran RSS

    Export to excel using script

    Srikanth P

      Hi folks,

      i have a script that exports an object to excel.

      i want to extend the script functionality to export only first 1000 records from the object.

       

      Script:

       

      SUB SendToExcel

      SET chart = ActiveDocument.GetSheetObject("CH01")

      SET p = chart.GetProperties

      chart.SendToExcel

      END SUB

       

      Please advise me how do i can limit the export to 'n' no. of rows.

       

      Thanks in advance.

       

      regards,

      Dathu