6 Replies Latest reply: Oct 22, 2013 11:02 AM by simone vaccaro RSS

    Export hidden column to xls

      hi all

      I've been searching and I know how to conditionally hide/show

      but yet to include it when users click the export to XLS button.

      i need a macro to xls that includes hidden columns

      i tried with :

       

      set obj = ActiveDocument.GetSheetObject("CH02")

      obj.SendToExcel

       

       

      but it doesn't work for hidden columns

      Can u help me pls?

       

      Ty