Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i want to export qlikview objects to excel/powerpoint on button click. But the object exported should work as if it is in QlikView.
Means if i click button, then the table or chart should change its data in excel/powerpoint.
Is it possible to do this in anyway? either using macros or any other method?
Hello,
I was not able to make that as default.
Could you please help me fixing the following issue?
I have 2 objects, one on 1st sheet and 2nd on the next sheet.
I was able to export the object on 1st sheet to the ppt and could not export the 2nd one, Beacuse it was not the Active sheet.
I tried the following from http://community.qlik.com/message/246942#246942
ActiveDocument.ActivateSheetByID "SH01"
It may also be necessary to restore the object (if it is minimized) with something like this:
ActiveDocument.GetSheetObject("CH03").Activate
But no Luck!!! Did you happen to try anything like this?
Hi..i have a similar request to export objects from both active and inactive sheets in a LAN drive. There are no minimized objects in my sheet. My active sheet is SH07. I have tried using the below lines but this exports only SH07 object and not SH06 (inactive sheet)
ActiveDocument.ActivateSheetbyId "SH06"
ActiveDocument.Sheets("SH06").Activate
ActiveDocument.Sheets("SH06").SheetObjects("CH254").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\Aging" & ".jpg"
ActiveDocument.ActivateSheetbyId "SH07"
ActiveDocument.Sheets("SH07").Activate
ActiveDocument.Sheets("SH07").SheetObjects("CH257").ExportBitmaptoFile "C:\Users\43862460\Reports\WIP\TestImages\SLA" & ".jpg"
Did you find any solution to this?
or for that matter only the last Activate sheet id statement. If I swap the statements of export of active and inactive sheets it just exports the last object and not but the objects..Any clues on how to proceed?
ActiveDocument.ActivateSheetbyId "SH07"
ActiveDocument.Sheets("SH07").Activate
ActiveDocument.Sheets("SH07").SheetObjects("CH257").ExportBitmaptoFile "C:\Users\43862460\Reports\WIP\TestImages\SLA" & ".jpg"
ActiveDocument.ActivateSheetbyId "SH06"
ActiveDocument.Sheets("SH06").Activate
ActiveDocument.Sheets("SH06").SheetObjects("CH254").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\Aging" & ".jpg"