Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
Hi,
Are you able to resolve this?
Regards,
Navdeep
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