How to export into separate sheets?

Andrius45 — Mon, 06 Mar 2017 08:44:06 GMT

Hey all,

So I have a macro which helps me to automatically export certain tables to excell sheet. Right now they are all exported to one sheet, is it possible to edit macro to make separate sheet for separate table?

Set curWorkBook = excelFile.WorkBooks.Add 'Create the WorkBook

Set curSheet = curWorkBook.WorkSheets(1) 'Create the Sheet

vArray = ActiveDocument.GetVariable("v_recipient_report").GetContent.String 'Get Report Number

chartArray =split(vArray, ",")

usedRows=0

For Each chart In chartArray

Set l = ActiveDocument.GetSheetObject(chart)

chartCaption = l.GetCaption.Name.v

curSheet.Cells(usedRows+1, 1)=chartCaption

l.CopyTableToClipboard true

curSheet.Cells(usedRows+3, 1).Select

curSheet.Paste

usedRows=curSheet.UsedRange.Rows.Count+3 '--->function to get the first unused row

Next 'loop end

topic How to export into separate sheets? in QlikView

How to export into separate sheets?