i want to export qlikview report to powerpoint

[udaya_kumar]

Hi,

i want to export the qlikview report to powerpoint (ppt or pptx) using OCX.

how to do this, can anyone help me out?

Thanks in advance

[Alexander_Thor]

What do you mean by report? A QlikView Defined Report or objects within a qlikview document?

If you want to embed QlikView Objects then go to powerpoint and insert object, you will find the QlikView OCX-Control in the list.

Then set your document and objects in the properties.

If you want to create a Powerpoint presentation from your QlikView Document this sample macro might do the trick for you.

Requires the IE Plugin or Desktop installed.

Sub ppt

'An array with the objects you want to export to powerpoint

Dim myArray(4)

myArray(0) = "CH64"

myArray(1) = "CH04"

myArray(2) = "CH65"

myArray(3) = "CH87"

myArray(4) = "CH68"

'Create ppt object

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

'Apply a template if you want one

objPresentation.ApplyTemplate _

    ("C:\mytemplate.potx")

'For each object in the array create a new slide and paste it.

For each item in myArray

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

ActiveDocument.GetSheetObject(item).CopyBitmapToClipboard

PPSlide.Shapes.Paste

Next

'Clean up

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

[udaya_kumar]

Hi alexander,

Thanks for valuable reply,

i want to export objects in the document to PPT.

The Client Requirement is to use OCX for Qlikview to export.

But how to use the OCX control in Powerpoint?

Can u help me?

[#4]

Hello Uday,

                    we can always copy image format of qlikview objects in powerpoint.

but i am not sure how to use OCX control in Powerpoint to copy object of Qlikview

thanks

Lavi

[#5]

I found your macro quite interesting.

Can you help me with your macro code if (1) I want to export objects from different QV sheets and (2) if I want to put two objects in one slide but at different places.

Jean.

[AlexOmetis]

The best way I've found to do this is to use a third party product called NPrinting - it allows you to design, filter & schedule the distribution of reports in PowerPoint format (as well as Excel, Word and HTML). Check it out at www.nprinting.com

[fgolmahi]

I'm want make a slide that inside a Qlikview report called.

In this example, both the attached example file should be together otherwise unresponsive

I am waiting for your help

[#8]

if you still search a pp macro send me email: wally_masur@safe-mail.net