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

[Anonymous]

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

[petter]

You find the answer to this here:

Type Mismatch on copyObjectsToExcelSheet

and here:

Type mismatch: 'copyObjectsToExcelSheet' | Qlik Community

[Anonymous]

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.