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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Siva_Sankar
Master II
Master II

Export objects from all sheets to ppt

Do any one have macros to export objects from multiple sheets to powerpoint?

i see macros for only activesheet of qlikview document

4 Replies
robert_mika
Master III
Master III

Have you managed to find answer to your question?

I have been trying to play with different way to achieve but I can not find the right way.

One path lead to put all objects from all sheets in array and then send all to ppt but I can not find a way to achieve this.

beck_bakytbek
Master
Master

i have some examples how to import to excel.if you want i give you some examples

Beck

robert_mika
Master III
Master III

Please share  if it takes all objects from all sheets - maybe we can find solution for ppt

beck_bakytbek
Master
Master

Hi Siva and Robert,

try this:

Sub PrintScreen()

ActiveDocument.ActivateSheet("yourSheet").CopyBitmapToClipboard.

End Sub

of course you can try to implent this expression on other objects/sheets

i hope, that helps

Beck