Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
angelaecheverri
Creator
Creator

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
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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
Creator
Creator
Author

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
Creator
Creator
Author

Does anyone know what could happend to me?

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