4 Replies Latest reply: Jun 20, 2014 8:08 AM by Christian Schwabe RSS

    filter with macro before export to excel

      Hello everyone,

       

      thank you very much for the support so far here. You are great.

       

      I have so far managed using a macro to export a table. However, these data should be filtered before export it, best also via Macro. Does anyone know of a way? The approaches presented here have not yet brought me to the destination.

      Thank you for your help.

       

      Kind regards,

      Chris

       

      My previous macro:

       

      Sub exportToExcel

        set obj = ActiveDocument.GetSheetObject("CH695_903948695")

        obj.ExportEx "E:\SASCHA_Export\test.xls", 5

        msgbox("Export successfully completed.")

      end sub