Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

2 Replies
petter
Partner - Champion III
Partner - Champion III

Anonymous
Not applicable
Author

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.