topic Re: Export to PPT issue in QlikView

Export to PPT issue

Thu, 13 Jun 2013 06:46:27 GMT

Can anyone tell me how to export to PPT?

I have tried writing a macro but it requires system access everytime qlikview is restarted. I have to provide system access my pressing Ctrl+Shift+M.

Is there any other turn around to export to PPT so that everytime system access need not be provided manually?

Thanks in advance!

Re: Export to PPT issue

sushil353 — Thu, 13 Jun 2013 07:06:18 GMT

Try the option:

Current local Security> Allow System Access.

HTH

Sushil

Re: Export to PPT issue

Thu, 13 Jun 2013 07:10:35 GMT

But we need to set the system access everytime qlikview is restarted.

Is there any solution to the problem that we need not give the access everytime but once?

Re: Export to PPT issue

sushil353 — Thu, 13 Jun 2013 07:15:22 GMT

Ok,

Try this:

Settings>User Prefereces>Security> uncheck Confirm Launch from Macro

Re: Export to PPT issue

Thu, 13 Jun 2013 07:32:52 GMT

Thanks Sushil but i am not able to proceed yet.

This is my code:

sub exportToPPT

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

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

ActiveDocument.ActiveSheet.CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

end Sub

I have to select option 1 in the dialog box in the attached image again.

Re: Export to PPT issue

sushil353 — Thu, 13 Jun 2013 07:34:39 GMT

Please post the sample app.

Re: Export to PPT issue

er_mohit — Thu, 13 Jun 2013 07:36:03 GMT

press ctrl +m

in requested module security --> System access

and in current local security also --> Allow system Access

then ok

hope it helps you

Re: Export to PPT issue

sushil353 — Thu, 13 Jun 2013 07:38:50 GMT

Hi,

I just checked your macro to my local machine.. i have given the system access and it is working perfect..

I am using qlikview 11.0 SR1. Which version you are using.?

Re: Export to PPT issue

sushil353 — Thu, 13 Jun 2013 07:39:39 GMT

Check out the attached application.

Re: Export to PPT issue

Thu, 13 Jun 2013 07:45:56 GMT

Thanks a lot er.mohit. It is working.
But still i am having a trouble in this. Once clicking on the button for "Export to PPT", qlikview takes me to the Macro editor (same as we have on pressing Ctrl+M). When i click again on the button after it, then only the PPT is generated. Any solution to it?

Re: Export to PPT issue

Thu, 13 Jun 2013 11:15:14 GMT

Thans er.mohit. It is working perfectly.

It is not working in web version. Any solution for this?

Re: Export to PPT issue

Thu, 13 Jun 2013 11:16:49 GMT

Thanks Sushil for your suggestion.

er.mohit' answer worked for me.

Re: Export to PPT issue

Fri, 02 Aug 2013 13:39:03 GMT

Hello Gentlemen

I have stolen shamelessly from this convesation and am very exitced about this. I have a couple of issues though

(..and this seems really stupid) When I click on the button, nothing happens....When I "Test" the Module, it executes the command well.
Using the script below, it will open excel, dump the contents (all the contents) as an image into a single PPT Sheet. I would prefer it do only the charts, is this possible or do I need to set up a special (Chart only sheet)
Is it posslble to put only selected chart or charts into a PPT?
Is it possible to have PPT add a page rather than open another PPT session each time I run the Macro

Thank you in advance for your thought and assistance