Export objects from all sheets to ppt

[Siva_Sankar]

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

i see macros for only activesheet of qlikview document

[robert_mika]

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]

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

Beck

[robert_mika]

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

[beck_bakytbek]

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