Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can anyone suggest me how to set the error
Type mismatch: 'copyObjectsToExcelSheet'
sub exportToExcel_Variant1
Dim aryExport(0,3)
aryExport(0,0) = "CH06"
aryExport(0,1) = "objsummary.Qlikview macro"
aryExport(0,2) = "A1"
aryExport(0,3) = "data"
Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)
end sub
Thanks.
You need to use the complete code not only snippets from the explanation: QlikTip #32: Exporting multiple QV objects to a single Excel document.
- Marcus
Thanks. when I am adding all and tried to execute excel file opening but not loading data.
do I need to make any changes?
Of course you need to do adjustments to your objects, paths, filenames and so on but based on the complete code from Stefan Walther. Maybe in the first steps you uncomment some things and used a few msgbox with variable-values or loop-counter or similar to minimize the complexity and to see what happens and which part didn't return the expected values.
- Marcus