Export to PPT issue

[#1]

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!

[sushil353]

Try the option:

Current local Security> Allow System Access.

HTH

Sushil

[#3]

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?

[sushil353]

Ok,

Try this:

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

[#5]

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.

[sushil353]

Please post the sample app.

[er_mohit · Accepted solution]

press ctrl +m

in requested module security --> System access

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

then ok

hope it helps you

[sushil353]

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.?

[sushil353]

Check out the attached application.

[#10]

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?