topic Re: Type mismatch: 'copyObjectsToExcelSheet' in QlikView

Type mismatch: 'copyObjectsToExcelSheet'

paul_ripley — Thu, 25 Feb 2016 17:56:49 GMT

Hello

I found this very useful article on how to send objects to excel using a macro

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

However I get the above error message

Now I am a beginner with macros and I have seen that people have mentioned this also before and apparently there is some code I am missing from the article but I can see what I have done wrong

The below is what I copied directly from the article and changed to reflect my objects.

What code am I missing as I am really stuck!

Thanks

Paul

sub exportToExcel_Variant1

Dim aryExport(0,3)

aryExport(0,0) = "CH01"

aryExport(0,1) = "InvestmentPortfolio"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

end sub

Re: Type mismatch: 'copyObjectsToExcelSheet'

settu_periasamy — Fri, 26 Feb 2016 03:04:10 GMT

Hi Paul,

I think your code is not completed.

copyObjectsToExcelSheet - not a Built-in Function. That is User Defined Function.

So, you need to Put the Complete Code..

There is a sample file which you have mentioned link : http://www.qlikblog.at/wp-content/uploads/2011/03/qlikblog_ExportToMultipleExcelSheets.zip

Let me know, if you are not able to download the file..

Re: Type mismatch: 'copyObjectsToExcelSheet'

paul_ripley — Mon, 29 Feb 2016 18:08:59 GMT

Thanks for your help

That helped me on the way

Paul