topic Re: Export to exccel getting error like Type mismatch: 'copyObjectsToExcelSheet' in QlikView

Export to exccel getting error like Type mismatch: 'copyObjectsToExcelSheet'

Anonymous — Wed, 18 Apr 2018 07:00:18 GMT

Hi All,

I am trying to export my charts data into excel for this I wrote macro but I am getting error message like

"Type mismatch: 'copyObjectsToExcelSheet' " .

Please anyone help me for resolving this. I am writing macro first time

I used the macro like

Dim aryExport(2,3)

aryExport(0,0) = "CH98"

aryExport(0,1) = "Sales per Region"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

aryExport(1,0) = "CH100"

aryExport(1,1) = "Top Customers"

aryExport(1,2) = "F1"

aryExport(1,3) = "data"

aryExport(2,0) = "CH101"

aryExport(2,1) = "Sales per Region a. Year"

aryExport(2,2) = "J1"

aryExport(2,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

Thanks in advance.

Regards,

Anusha

Re: Export to exccel getting error like Type mismatch: 'copyObjectsToExcelSheet'

petter — Wed, 18 Apr 2018 09:34:04 GMT

You find the answer to this here:

Type Mismatch on copyObjectsToExcelSheet

and here:

Type mismatch: 'copyObjectsToExcelSheet' | Qlik Community

Re: Export to exccel getting error like Type mismatch: 'copyObjectsToExcelSheet'

Anonymous — Wed, 18 Apr 2018 11:45:20 GMT

Thank you petter for your reply but I already seen those posts but the Macro presented in that QVW is not working triggering some error when I tried to test the macro.