Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Export every sheets to PPT

Dear Community,

To export sheet to PPT by using macro, I have the code as shown below, but it's working weird as it only export one of the sheet image to PPT while the other 2 sheet images in blank.

Kindly give a hint to correct my code.

Sub ppt

Dim myArray(2)

myArray(0) = "SH_Media_Performance"          'my sheet ID_1

myArray(1) = "SH_Catalogues"                         'my sheet ID_2

myArray(2) = "SH_Executive_Summary"               'my sheet ID_3

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

For count = 0 to ubound(MyArray)

Set PPSlide = objPresentation.Slides.Add(1,11)


Set t=ActiveDocument.ActiveSheet



if count = 3 then exit sub


Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

The weird PPT came out after running the macro, the correct result should show 3 sheet images in 3 slides.


Warm regards,


5 Replies
Honored Contributor III

Re: Export every sheets to PPT


Sending you macros Steps for Creation of PDF you have to find little code and replace for ppt.

Hope This will help you to achieve.

Good Luck


Not applicable

Re: Export every sheets to PPT

Thanks Vikas for your solution, I tried to click on button "Make PDF", it prompt out the window to key in *contact number, which mean it will create pdf file and send it to phone?

After key in phone number, it mentioned "printing" but nothing appear.

May I know how to make it work?

Not applicable

Re: Export every sheets to PPT

Hi Chanel Choo,

So you managed to do it?

Not applicable

Re: Export every sheets to PPT

Sorry, i haven't get a solution for this yet. Hope that you can update here if you have any good solution!

Thanks and best regards,


Not applicable

Re: Export every sheets to PPT


I also haven't get any solution. But I received a link from one of the community here..Maybe this can help. I'm looking on it.


Community Browser