Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kvijay173
New Contributor III

Type Mismatch on copyObjectsToExcelSheet

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)

Tags (1)
1 Solution

Accepted Solutions

Re: Type Mismatch on copyObjectsToExcelSheet

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

2 Replies
Not applicable

Re: Type Mismatch on copyObjectsToExcelSheet

Hi,

Are you able to resolve this?

Regards,

Navdeep

Re: Type Mismatch on copyObjectsToExcelSheet

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

Community Browser