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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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