topic Re: objects in powerpoint in QlikView

objects in powerpoint

Tue, 14 Feb 2012 07:09:07 GMT

Hi guys,

I am a very new user - QV11 and would like to find out that i can import qv objects to PowerPoint. I i'd just like to know if there is a way of automatically updating the ppt document? And can one write a script in visual c#? Please help!

objects in powerpoint

Anonymous — Tue, 14 Feb 2012 08:07:10 GMT

Hi thaborabs,

We can export the qv objects to ppt using the macro(vbscript).

Below i mentioned some example script to export the qv objects to ppt .

sub powerpoint

Set PPApp = CreateObject("Powerpoint.Application")

PPApp.Visible = True

Set PPPres = PPApp.Presentations.Open ("C:\xxx\xxx.ppt")
PPApp.Visible = True

ActiveDocument.Reload

ActiveDocument.GetApplication.WaitForIdle

set s=ActiveDocument.Sheets("Summary")
ActiveDocument.Sheets("Summary").Activate
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.GetSheetObject("CH28").Restore
ActiveDocument.GetSheetObject("CH28").CopyBitmapToClipboard
PPApp.Visible = True
Set PPSlide = PPPres.Slides(11)
PPSlide.Shapes.Paste
ActiveDocument.GetSheetObject("CH28").Minimize
ActiveDocument.GetApplication.WaitForIdle

set PPApp = nothing
set PPPRes = nothing
set PPSlide = nothing

ActiveDocument.SaveAs "C:\xxx\xxx.qvw"
ActiveDocument.GetApplication.Quit
end sub

Try this and let me know your feedback.

Regards

Ashok

objects in powerpoint

Tue, 14 Feb 2012 08:38:13 GMT

Hi Ashok,

Thank you for your reply.

When loading the script in the edit module window and hitting the 'test' button i get a message that "ActiveX component can't create object: ("Powerpoint.Application").

Could this be that i am running on QV Personal Edition?

objects in powerpoint

CELAMBARASAN — Tue, 14 Feb 2012 08:45:03 GMT

Hi,

It needs the Microsoft office to be installed with powerpoint presentation. Have you installed ?

Celambarasan

objects in powerpoint

CELAMBARASAN — Tue, 14 Feb 2012 08:47:30 GMT

Hi,

Check Requested module security in the edit module dialog is selected as System Access and also check the current local security.

Celambarasan

objects in powerpoint

Tue, 14 Feb 2012 09:08:07 GMT

hi,

Microsoft office is installed on my workstation yes.

objects in powerpoint

Tue, 14 Feb 2012 09:22:16 GMT

It works.

The issue was the security settings. Thanks aMillion guys.

Re: objects in powerpoint

Wed, 15 Feb 2012 05:47:50 GMT

HI,

The script you wrote me runs until ActiveDocument.GetApplication.WaitForIdle

From there highlights the next line set s=ActiveDocument.Sheets("Summary")

Any idea as to why it may be doing so?

objects in powerpoint

CELAMBARASAN — Wed, 15 Feb 2012 06:51:47 GMT

Hi,

Its may be you don't have the sheet summary.Please look in to that.

Celambarasan

Re: objects in powerpoint

Wed, 15 Feb 2012 07:10:02 GMT

hi Celambarasan,

Please provide more clarity as to what you mean by saying ‘don't have the sheet summary’

thank you.

objects in powerpoint

Anonymous — Wed, 15 Feb 2012 07:53:07 GMT

In the ppt macro

set s=ActiveDocument.Sheets("Summary") - the "summary" is the qv file sheet Name.

You can change the name based on your qv file sheet name through Settings --> sheet properties --->Tiltle

See the image :

Regards

Ashok

Re: objects in powerpoint

Anonymous — Wed, 15 Feb 2012 07:54:14 GMT

see the attached image file.

Re: objects in powerpoint

Wed, 15 Feb 2012 09:12:35 GMT

Hi,

The script work perfectly. Thank you very much.

Is there any way to copy an active sheet object instead of a static object?

Re: objects in powerpoint

Anonymous — Wed, 15 Feb 2012 09:35:48 GMT

I can not catch what you are asking .

Please give me some example for static object what you mean

Regards

Ashok

Re: objects in powerpoint

Wed, 15 Feb 2012 09:51:03 GMT

Ok. This current script only creates a copy of the object and places it as an image in the ppt page(static), what I would like to know is if the active object – mean an object that is clickable can be added through the script?

Re: objects in powerpoint

AlexOmetis — Wed, 19 Dec 2012 15:08:45 GMT

You can do this all through NPrinting (www.nprinting.com) a third party tool... without coding macros, changing seciruty settings or anything. It's still a static version of the object from QlikView, but you can filter, schedule updates and distribution with it as well...