Type mismatch: 'copyObjectsToExcelSheet'

[#1]

Hi,

can anyone suggest me how to set the error

Type mismatch: 'copyObjectsToExcelSheet'

sub exportToExcel_Variant1

Dim aryExport(0,3)

aryExport(0,0) = "CH06"

aryExport(0,1) = "objsummary.Qlikview macro"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

end sub

Thanks.

[marcus_sommer]

You need to use the complete code not only snippets from the explanation: QlikTip #32: Exporting multiple QV objects to a single Excel document.

- Marcus

[#3]

Thanks. when I am adding all and tried to execute excel file opening but not loading data.

do I need to make any changes?

[marcus_sommer]

Of course you need to do adjustments to your objects, paths, filenames and so on but based on the complete code from Stefan Walther. Maybe in the first steps you uncomment some things and used a few msgbox with variable-values or loop-counter or similar to minimize the complexity and to see what happens and which part didn't return the expected values.

- Marcus