Discussion Board for collaboration on QlikView Layout & Visualizations.
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...
You can use a macro. You can find an flexible example here. Or you can try something like this:
set XL = CreateObject("Excel.Application")
set WB = XL.Workbooks.Addset SH1 = WB.Worksheets(1)set SH2 = WB.Worksheets(2)
ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard trueSH1.Paste SH1.Range("A1")
ActiveDocument.GetSheetObject("CH02").CopyTableToClipboard trueSH2.Paste SH2.Range("A1")
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....
Does anyone know what could happend to me?
My macro havent show a mistake.... but it doesnt run...