Type Mismatch on copyObjectsToExcelSheet

[Anonymous]

Error:Type Mismatch on copyObjectsToExcelSheet

I am trying excel objects to different sheets within the same excel.

I tried the below code and getting the error. Any suggestions please.

Dim aryExport(0,3)

aryExport(0,0) = "CH25"

aryExport(0,1) = "Sales"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = CopyObjectsToExcelSheet(ActiveDocument, aryExport)

[#2]

Hi,

Are you able to resolve this?

Regards,

Navdeep

[marcus_sommer · Accepted solution]

The reason is that the code is incomplete - some important parts from example are missing. The displayed code-snippets are only to demonstrate some thing - you need to use the complete code from example (and adjust it then to your objects, paths and so on).

QlikTip #32: Exporting multiple QV objects to a single Excel document

- Marcus