topic Add rows to excel in QlikView https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734645#M1080489 <HTML><HEAD></HEAD><BODY><P>hi guys,</P><P></P><P>I need to know a macro code to add rows in excel by the qlick view,</P><P></P><P>My code paste a table from qlick view to excel but I need insert some empty lines in the middle of table.</P><P></P><P>Does anyone know how to do that?</P><P></P><P>I use the function below to add workbooks, but rows I dont know</P><P></P><P>Set objExcelDoc = objExcelApp.Workbooks.Add</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 08 Jul 2014 14:39:08 GMT 2014-07-08T14:39:08Z Add rows to excel https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734645#M1080489 <HTML><HEAD></HEAD><BODY><P>hi guys,</P><P></P><P>I need to know a macro code to add rows in excel by the qlick view,</P><P></P><P>My code paste a table from qlick view to excel but I need insert some empty lines in the middle of table.</P><P></P><P>Does anyone know how to do that?</P><P></P><P>I use the function below to add workbooks, but rows I dont know</P><P></P><P>Set objExcelDoc = objExcelApp.Workbooks.Add</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 08 Jul 2014 14:39:08 GMT https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734645#M1080489 2014-07-08T14:39:08Z Re: Add rows to excel https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734646#M1080490 <HTML><HEAD></HEAD><BODY><P>You'd probably have to shell out to take control of the Excel sheet, then apply normal Excel VBA, then return back to QV, I imagine.</P></BODY></HTML> Tue, 08 Jul 2014 15:05:46 GMT https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734646#M1080490 ThornOfCrowns 2014-07-08T15:05:46Z Re: Add rows to excel https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734647#M1080491 <HTML><HEAD></HEAD><BODY><P>How can I do that?</P></BODY></HTML> Tue, 08 Jul 2014 16:01:23 GMT https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734647#M1080491 2014-07-08T16:01:23Z Re: Add rows to excel https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734648#M1080492 <HTML><HEAD></HEAD><BODY><P>I found the expression tks all.</P><P></P><P>objExcelDoc.Sheets(sheetName).Rows("313:313").Insert</P></BODY></HTML> Thu, 10 Jul 2014 14:17:36 GMT https://community.qlik.com/t5/QlikView/Add-rows-to-excel/m-p/734648#M1080492 2014-07-10T14:17:36Z