Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
How can I do that?
I found the expression tks all.
objExcelDoc.Sheets(sheetName).Rows("313:313").Insert