Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

udaya_kumar
Valued Contributor

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

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?

Tags (1)
Labels (1)
1 Solution

Accepted Solutions
udaya_kumar
Valued Contributor

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

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

14 Replies
MVP
MVP

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

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
Valued Contributor

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

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

MVP
MVP

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

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
Valued Contributor

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

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
Valued Contributor

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

Hello experts,

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

still its not solved..

udaya_kumar
Valued Contributor

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

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

Not applicable

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

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
Valued Contributor

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

What is the error which you are getting?

Not applicable

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

It creates a blank PPT. thats it.