Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

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?

Labels (1)
1 Solution

Accepted Solutions
udaya_kumar
Specialist
Specialist
Author

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

View solution in original post

14 Replies
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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

Hello experts,

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

still its not solved..

udaya_kumar
Specialist
Specialist
Author

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

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
Specialist
Specialist
Author

What is the error which you are getting?

Not applicable

It creates a blank PPT. thats it.