10 Replies Latest reply: Dec 8, 2016 5:44 AM by Murugesan Narayanan RSS

    Exporting to multiple Tabs of the same Excel file

    Vladimir Komarov



      I am exporting some of my tables to Excel using the following:


      set objExport = ActiveDocument.GetSheetObject("CH24")

      objExport.ExportEx fileName1,5


      set objExport = ActiveDocument.GetSheetObject("CH59")

      objExport.ExportEx fileName2,5



      Is it possible to create multiple tabs in the same Excel file and export each chart to separate tabs, and not separate files like above?


      Looking forward to suggestions.


      Best regards,