3 Replies Latest reply: Jul 23, 2015 5:31 AM by Steven Grice RSS

    Macro to copy table data without column names

    Carly McClintock

      Hi,

       

      I have created a macro to export a number of QlikView tables to a predefined excel template. However I would like to export the table data only without the column names.

       

      This is an example of the current copy and paste logic in the macro:

      ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (true)
      XLSheet.Paste XLSheet.Range("A22")


      Can anyone advise me how to change this to exclude the column names?