topic Re: Macro to copy table data without column names in QlikView https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911355#M653506 <HTML><HEAD></HEAD><BODY><P>Ahhh so simple, lets pretend I haven't been scratching my head for an hour&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P></P><P>Thanks </P></BODY></HTML> Thu, 23 Jul 2015 09:04:18 GMT 2015-07-23T09:04:18Z Macro to copy table data without column names https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911353#M653504 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>This is an example of the current copy and paste logic in the macro:</P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (true)<BR /> XLSheet.Paste XLSheet.Range("A22")</SPAN></P><P><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: #808080;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><SPAN style="color: #808080; font-size: 10pt; font-family: arial, helvetica, sans-serif;">Can anyone advise me how to change this to exclude the column names?</SPAN><BR /></SPAN></P></BODY></HTML> Thu, 23 Jul 2015 07:54:59 GMT https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911353#M653504 2015-07-23T07:54:59Z Re: Macro to copy table data without column names https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911354#M653505 <HTML><HEAD></HEAD><BODY><P>ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (<SPAN style="font-size: 14pt;"><STRONG>false</STRONG></SPAN>)</P><P>XLSheet.Paste XLSheet.Range("A22")</P></BODY></HTML> Thu, 23 Jul 2015 08:49:08 GMT https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911354#M653505 sgrice 2015-07-23T08:49:08Z Re: Macro to copy table data without column names https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911355#M653506 <HTML><HEAD></HEAD><BODY><P>Ahhh so simple, lets pretend I haven't been scratching my head for an hour&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P></P><P>Thanks </P></BODY></HTML> Thu, 23 Jul 2015 09:04:18 GMT https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911355#M653506 2015-07-23T09:04:18Z Re: Macro to copy table data without column names https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911356#M653507 <HTML><HEAD></HEAD><BODY><P>Here the APIguide app to help with macros</P></BODY></HTML> Thu, 23 Jul 2015 09:31:00 GMT https://community.qlik.com/t5/QlikView/Macro-to-copy-table-data-without-column-names/m-p/911356#M653507 sgrice 2015-07-23T09:31:00Z