topic Re: Export objects from all sheets to ppt in QlikView

Export objects from all sheets to ppt

Siva_Sankar — Tue, 28 Apr 2015 12:50:48 GMT

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

i see macros for only activesheet of qlikview document

robert_mika — Tue, 05 May 2015 08:44:58 GMT

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 — Tue, 05 May 2015 08:59:04 GMT

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

Beck

robert_mika — Tue, 05 May 2015 09:12:56 GMT

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

beck_bakytbek — Tue, 05 May 2015 09:49:26 GMT

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