Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro to copy table data without column names

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?

1 Solution

Accepted Solutions
sgrice
Partner - Creator II
Partner - Creator II

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

XLSheet.Paste XLSheet.Range("A22")

View solution in original post

3 Replies
sgrice
Partner - Creator II
Partner - Creator II

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

XLSheet.Paste XLSheet.Range("A22")

Not applicable
Author

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

Thanks

sgrice
Partner - Creator II
Partner - Creator II

Here the APIguide app to help with macros