I want to copy the object to .pptx from.qvw through marco

[thankuever]

HI ALL

I want to copy the object ID "CH53" to .pptx(test.pptx) from.qvw  through marco.

But when I test the marco ,it just open PowerPoint and nothing happened.

and i have a question

Set PPSlide = PPPres.Slides(1)   <--------------It means paste a object at first page of ppt?

Thanks a lot.

Amy

_________________________________________________________________________-

Sub ppt

'Create ppt object

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set PPPres = objPPT.Presentations.Open("C:\Users\amy\Desktop\test.pptx")

Set PPSlide = PPPres.Slides(1)

ActiveDocument.GetSheetObject("CH53").CopyBitmapToClipboard

with PPSlide.Shapes.Paste

.Left  = 20

.Top  = 80

.Width = 400

.Height = 400

end with

END SUB

[Anil_Babu_Samineni]

Try This

i want to export qlikview report to powerpoint

[akash3191]

I would suggest you to use Qlikview NPrinting for this.

It is a great reporting tool that will help you to send qlikview objects to excel/word/ppt/html format.

Thanks,

Akash.

[marcus_sommer]

Take a look here: Automated PowerPoint Presentation Extraction

- Marcus

[Frank_Hartmann]

Have a look at attached files.

And setup the correct settings in Module:

hope this helps