topic Macro copy to excel in QlikView https://community.qlik.com/t5/QlikView/Macro-copy-to-excel/m-p/673670#M1076966 <HTML><HEAD></HEAD><BODY><P>I have a macro which copies data into an excelsheet:</P><P></P><P></P><P></P><P></P><P>Set XLDoc = XLSapp.Workbooks.add 'Open New Excel file</P><P></P><P>XLDoc.Sheets.Add.Name = "Kwaliteit" 'Add sheet</P><P></P><P>ActiveDocument.GetSheetObject("CH06").CopyTableToClipboard True 'Add table with fieldinfo</P><P></P><P>XLDoc.Worksheets("Kwaliteit").Range("A1").Select()</P><P></P><P>XLDoc.Worksheets("Kwaliteit").PasteSpecial</P><P></P><P>XLDoc.Worksheets("Kwaliteit").cells.WrapText = False</P><P></P><P>Works perfectly, but now I want to add some tekst (amd preferably the name of the sheet) to cell A1, and starting A2 the actual table.</P><P></P><P>Is this possible? </P></BODY></HTML> Tue, 29 Jul 2014 14:42:14 GMT 2014-07-29T14:42:14Z Macro copy to excel https://community.qlik.com/t5/QlikView/Macro-copy-to-excel/m-p/673670#M1076966 <HTML><HEAD></HEAD><BODY><P>I have a macro which copies data into an excelsheet:</P><P></P><P></P><P></P><P></P><P>Set XLDoc = XLSapp.Workbooks.add 'Open New Excel file</P><P></P><P>XLDoc.Sheets.Add.Name = "Kwaliteit" 'Add sheet</P><P></P><P>ActiveDocument.GetSheetObject("CH06").CopyTableToClipboard True 'Add table with fieldinfo</P><P></P><P>XLDoc.Worksheets("Kwaliteit").Range("A1").Select()</P><P></P><P>XLDoc.Worksheets("Kwaliteit").PasteSpecial</P><P></P><P>XLDoc.Worksheets("Kwaliteit").cells.WrapText = False</P><P></P><P>Works perfectly, but now I want to add some tekst (amd preferably the name of the sheet) to cell A1, and starting A2 the actual table.</P><P></P><P>Is this possible? </P></BODY></HTML> Tue, 29 Jul 2014 14:42:14 GMT https://community.qlik.com/t5/QlikView/Macro-copy-to-excel/m-p/673670#M1076966 2014-07-29T14:42:14Z