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

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

udaya_kumar — Mon, 26 Jan 2026 18:19:17 GMT

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?

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

Miguel_Angel_Baeyens — Tue, 24 Apr 2012 10:55:35 GMT

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

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

udaya_kumar — Tue, 24 Apr 2012 11:26:40 GMT

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

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

Miguel_Angel_Baeyens — Tue, 24 Apr 2012 11:50:09 GMT

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

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

udaya_kumar — Tue, 24 Apr 2012 12:14:23 GMT

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?

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

udaya_kumar — Tue, 15 May 2012 05:33:17 GMT

Hello experts,

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

still its not solved..

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

udaya_kumar — Wed, 01 Aug 2012 07:17:44 GMT

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

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

Tue, 02 Apr 2013 14:46:33 GMT

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

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

udaya_kumar — Tue, 02 Apr 2013 14:55:11 GMT

What is the error which you are getting?

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

Tue, 02 Apr 2013 14:58:22 GMT

It creates a blank PPT. thats it.

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

udaya_kumar — Tue, 02 Apr 2013 15:08:52 GMT

Arpan,

Then in that case for debugging the code.

Just add the below code in your code

msgbox 1

and check in every line by adding this msgbox.

so that you can find out, on which line you are getting an error.

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

Tue, 02 Apr 2013 15:15:31 GMT

I used the following:

ActiveDocument.GetSheetObject("TX01").CopyBitmapToClipboard

msgbox 1

When I run the code it opens a blank presentation that't it and doesn't display the message box. Also it highlights the ActiveDocument....code.

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

MichaelTerenzi — Wed, 03 Apr 2013 18:33:03 GMT

In the PowerPoint presentation itself, check to see if any objects pasted as blank white objects, then check "Keep Source Formatting" in the object properties. Sometimes this will help objects render in Power Point when the formatting is altered by PP.

I have been ablet o get the above code to run without a hitch in my environment. Make sure to

hit Ctrl + Shift + M in the application and grant System Access, or Ctrl + M and grant System Access under both drop downs.

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

Tue, 22 Apr 2014 10:14:34 GMT

Hi,

Your export to PPT is working fine in IE plugin???

and if yes, can you please give the macro to me...

Thanks alot.

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

Tue, 27 May 2014 15:19:09 GMT

Hey everyone !

I get the same error "ActiveX component can't create object: 'Powerpoint.Application'" when I use a macro.

From what I've read, Powerpoint has to be installed on the same server that the one which has the licence i'm leasing, is that right ?

Because, I've installed powerpoint on the server where I developped some application. The licence I use is rent from another server.

Thank you for your answer