Macro to copy table data without column names

[#1]

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?

[sgrice · Accepted solution]

ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (false)

XLSheet.Paste XLSheet.Range("A22")

[#3]

Ahhh so simple, lets pretend I haven't been scratching my head for an hour 

Thanks

[sgrice]

Here the APIguide app to help with macros