ActiveX component can't create object: 'PowerPoint.Application' error on IE Plugin

[udaya_kumar]

Hi,

i have written a macro to export charts to ppt.

its working fine in QlikView Document, but not working in Access Point.

Its giving error "ActiveX Component Cant create object: 'PowerPoint.Application' error in IE Plugin

i tried checking that select 'Allow System Access' Option also, but also macro not working.

so what could be the problem?

[Miguel_Angel_Baeyens]

Hi,

Is the server allowing execution of unsafe macros? Check in the QEMC, System, Setup, QlikView Servers, Security. Check in the settings of the module editor, both requested and current (in the left part) are allowing system access.

Apart from that, does the server installed PowerPoint? Otherwise it won't work.

Hope that helps.

Miguel

[udaya_kumar]

Hi Miguel,

i checked it, Allow unsafe macro execution is checked and even allow run macro in server is checked.

and also powerpoint is installed in Server. i have made allow system access before publishing in QVW file.

but still its not working

[Miguel_Angel_Baeyens]

Hi,

I assume it works when executed locally in the Server computer using the Desktop. Is that right? How are you setting the paths? Are you using mapped drives? If not, are the UNC paths available to the user running the services? Has the computer running the IE plugin PowerPoint as well? If so, which version?

Hope that gives you a hint on where to move on.

Miguel

[udaya_kumar]

Hi Miguel,

yes, it works well in locally in the Server Computer in the Desktop.

I am having Powerpoint 2007 version, i think ie plugin is installed for that.

which path are you asking?

[udaya_kumar]

Hello experts,

can anybody suggest me or give me the solution for this problem?

still its not solved..

[udaya_kumar · Accepted solution]

Hi everyone,

I got the solution in the QlikView Community itself.

In the Web Browser, do Ctrl + Shift + M and change the option to Give System access to Module editor.

it will work fine

[#8]

I am using the following code to export QV file to PPT but getting an error, please help.

ActiveDocument.GetSheetObject("CH39").CopyBitmapToClipboard

------------------------------------------------

Sub ExportPPT

Set PPApp = CreateObject("Powerpoint.Application")

PPApp.Visible = True

Set PPPres = PPApp.Presentations.Add
PPApp.Visible = True

ActiveDocument.GetApplication.WaitForIdle

set s=ActiveDocument.Sheets("Customers")
ActiveDocument.Sheets("Customers").Activate
ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ClearAll False

PPApp.Visible = True

Set PPSlide = PPPres.Slides.ADD(1,11)

ActiveDocument.GetSheetObject("CH39").Restore
ActiveDocument.GetSheetObject("CH39").CopyBitmapToClipboard

PPSlide.Shapes.Paste

with PPSlide.Shapes(PPSlide.Shapes.Count)
.left = 0
.top = 200
.width=720
end with

PPPres.SaveAs ("C:\Test.pptx")
PPPres.Close
PPApp.Quit

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

End Sub

[udaya_kumar]

What is the error which you are getting?

[#10]

It creates a blank PPT. thats it.