How to export chart items data into one excel workbook as separate sheets?

[#1]

Hi,

I have four chart items where data export to excel workbook in to three separate sheets. In those four chart items, one is image and remaining three are table data.

Everyday there is excel file placed with template into C folder where the path is

C:CustomerData\customerInfo_26022015.xlsx

if we take tomorrow it will get as C:CustomerData\CustomerInfo_27022015.xlsx

and so on everyday.

in excel CustomerInfo_XXXXXXXX.xlsx there are three sheets A, B and C. After these three sheets the chart items should populate. up to now everyday I am manually adding chart items next to C sheet.

I want to stop this manual load. Is there any possibility with the help of macro I can do this export into CustomerInfo_XXXXXXXX.xlsx excel workbook.

Please can anyone suggest me.

Thanks.

[Gysbert_Wassenaar]

See this blog post: QlikTip #32: Exporting multiple QV objects to a single Excel document

[#3]

Thanks. I have tried this. when I am using

Sample 2: More enhanced export of three objects to three different sheets

it is showing error as

Type mismatch: 'copyObjectsToExcelSheet'

[ljackson]

Hi Amelia

Did you work out a solution to the mismatch error?   I am having the same trouble, but my very limited knowledge of macro writing is letting me down!!!

Thanks

Leah

[#5]

no not yet

[#6]

I tried many ways. nothing seems to be not working . please can anyone suggest me how to sort out this