Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (false)
XLSheet.Paste XLSheet.Range("A22")
ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (false)
XLSheet.Paste XLSheet.Range("A22")
Ahhh so simple, lets pretend I haven't been scratching my head for an hour
Thanks
Here the APIguide app to help with macros