topic Re: Export ALL sheets to ppt in QlikView https://community.qlik.com/t5/QlikView/Export-ALL-sheets-to-ppt/m-p/886202#M530287 <HTML><HEAD></HEAD><BODY><P>try here (answers from autopilot)</P><P><A href="https://community.qlik.com/message/609224">Re: Re: Macro to export more than one Sheet objects into PPT</A></P></BODY></HTML> Tue, 23 Jun 2015 20:31:54 GMT maxgro 2015-06-23T20:31:54Z Export ALL sheets to ppt https://community.qlik.com/t5/QlikView/Export-ALL-sheets-to-ppt/m-p/886201#M530286 <HTML><HEAD></HEAD><BODY><P>Hi all, I wonder if you have had the quest to export all the sheets into powerpoint.</P><P>1. I have found this following code work very well when I exporting the ACTIVE sheet into powerpoint, but how do I export ALL sheets?</P><P>2. How do export selected few sheets? e.g. exporting "Sheet1", "Sheet4", and "Sheet5"?</P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14350907950469880" jivemacro_uid="_14350907950469880"> <P>Sub exportppt</P> <P></P> <P></P> <P>Set objPPT = CreateObject("PowerPoint.Application")</P> <P>objPPT.Visible = True</P> <P>Set objPresentation = objPPT.Presentations.Add</P> <P></P> <P>Set PPSlide = objPresentation.Slides.Add(1,11)</P> <P>ActiveDocument.ActiveSheet.CopyBitmapToClipboard</P> <P>PPSlide.Shapes.Paste</P> <P></P> <P>Set PPSlide = Nothing</P> <P>Set PPPres = Nothing</P> <P>Set PPApp = Nothing</P> <P></P> <P>End Sub </P> </PRE><P></P><P>Thanks very much for the help!</P><P></P><P>Mira</P></BODY></HTML> Tue, 23 Jun 2015 20:21:55 GMT https://community.qlik.com/t5/QlikView/Export-ALL-sheets-to-ppt/m-p/886201#M530286 2015-06-23T20:21:55Z Re: Export ALL sheets to ppt https://community.qlik.com/t5/QlikView/Export-ALL-sheets-to-ppt/m-p/886202#M530287 <HTML><HEAD></HEAD><BODY><P>try here (answers from autopilot)</P><P><A href="https://community.qlik.com/message/609224">Re: Re: Macro to export more than one Sheet objects into PPT</A></P></BODY></HTML> Tue, 23 Jun 2015 20:31:54 GMT https://community.qlik.com/t5/QlikView/Export-ALL-sheets-to-ppt/m-p/886202#M530287 maxgro 2015-06-23T20:31:54Z