topic Re: Type mismatch: 'copyObjectsToExcelSheet' in QlikView

Type mismatch: 'copyObjectsToExcelSheet'

Fri, 31 Jul 2015 15:11:22 GMT

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.

Re: Type mismatch: 'copyObjectsToExcelSheet'

marcus_sommer — Fri, 31 Jul 2015 15:23:14 GMT

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

Re: Type mismatch: 'copyObjectsToExcelSheet'

Fri, 31 Jul 2015 15:36:28 GMT

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

do I need to make any changes?

Re: Type mismatch: 'copyObjectsToExcelSheet'

marcus_sommer — Fri, 31 Jul 2015 15:43:28 GMT

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