Add rows to excel

[#1]

hi guys,

I need to know a macro code to add rows in excel by the qlick view,

My code paste a table from qlick view to excel but I need insert some empty lines in the middle of table.

Does anyone know how to do that?

I use the function below to add workbooks, but rows I dont know

Set objExcelDoc = objExcelApp.Workbooks.Add

Thanks.

[ThornOfCrowns]

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.

[#3]

How can I do that?

[#4]

I found the expression tks all.

objExcelDoc.Sheets(sheetName).Rows("313:313").Insert