topic Re: Export every sheets to PPT in QlikView

Export every sheets to PPT

Wed, 04 Sep 2013 02:15:27 GMT

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)

ActiveDocument.Sheets(myArray(count)).Activate

Set t=ActiveDocument.ActiveSheet

t.CopyBitmapToClipboard

PPSlide.Shapes.Paste

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,

Chanel

Re: Export every sheets to PPT

vikasmahajan — Wed, 04 Sep 2013 04:04:55 GMT

Hii

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

Vikas

Re: Export every sheets to PPT

Wed, 04 Sep 2013 08:44:40 GMT

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?

Re: Export every sheets to PPT

Fri, 22 Nov 2013 05:42:01 GMT

Hi Chanel Choo,

So you managed to do it?

Re: Export every sheets to PPT

Fri, 22 Nov 2013 07:46:28 GMT

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,

Chanel

Re: Export every sheets to PPT

Wed, 27 Nov 2013 06:36:26 GMT

Hi,

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.

http://community.qlik.com/docs/DOC-3774