topic Re: Type Mismatch on copyObjectsToExcelSheet in QlikView

Type Mismatch on copyObjectsToExcelSheet

Anonymous — Tue, 09 Jun 2015 11:49:39 GMT

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)

Re: Type Mismatch on copyObjectsToExcelSheet

Thu, 01 Oct 2015 08:54:03 GMT

Hi,

Are you able to resolve this?

Regards,

Navdeep

Re: Type Mismatch on copyObjectsToExcelSheet

marcus_sommer — Thu, 01 Oct 2015 09:11:37 GMT

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