Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

angelaecheverri
Contributor

How can I Export multiples charts to excel in the same workbook

Hi dears..

i have multiples charts that i need to export to a one workbook but in differents sheets.

I have Office 2010 and the examples i had found didnt work for me...

thanks

AE

3 Replies

Re: How can I Export multiples charts to excel in the same workbook

You can use a macro. You can find an flexible example here. Or you can try something like this:

Sub Exp2XL

set XL = CreateObject("Excel.Application")

set WB = XL.Workbooks.Add
set SH1 = WB.Worksheets(1)
set SH2 = WB.Worksheets(2)

ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard true
SH1.Paste SH1.Range("A1")

ActiveDocument.GetSheetObject("CH02").CopyTableToClipboard true
SH2.Paste SH2.Range("A1")

End Sub


talk is cheap, supply exceeds demand
angelaecheverri
Contributor

Re: How can I Export multiples charts to excel in the same workbook

Thanks Gysbert

Its seem too easy but i dont know why it didnt work !

all the macros i had found when i excecute them make me go to teh script again..

and didnt work...

but i dont have any clue about the problem....

angelaecheverri
Contributor

Re: How can I Export multiples charts to excel in the same workbook

Does anyone know what could happend to me?

My macro havent show a mistake.... but it doesnt run...

Community Browser