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: 
Not applicable

Export//macro and IE Plugin ?

Hi,

I have read many threads in QV community around how to export graphs and tables in ppt/excel or word. and various versions of macro to do this.

After trying many, I still encounter the same error when I run any macro with the following command :

Set PPApp = CreateObject("Powerpoint.Application")

The error shown is:

ActiveX component can't create object: 'Powerpoint.Application'

By reading left and right in the community forums, I understood that my macro will not work until I have the QV IE plugin installed.

What I want to do :

Automate creation of a ppt presentation with key graph and tables (not dynamic)

What do I use :

QV 9 (client, not server)

Windows 7

Microsoft powerpoint 2003

LEt me know :

1. If my understanding is correct ie I need IE plugin

2. If correct, where do I download it (QV website does not have any download plugin option anymore)

3. Is there any risk, limitation due to the installation of the plugin.


Thanks

TD

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

Macro security must be set to System level, and PowerPoint must be installed on the client computer.

Check macro sescurity by tyoeing Shift+Ctrl+M.

View solution in original post

2 Replies
m_woolf
Master II
Master II

Macro security must be set to System level, and PowerPoint must be installed on the client computer.

Check macro sescurity by tyoeing Shift+Ctrl+M.

Not applicable
Author

Thanks mwoolf, it is working.

What is the IE plugin for anyway ?