Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.