Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
mwoolf
Honored Contributor II

Re: Export//macro and IE Plugin ?

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.

2 Replies
mwoolf
Honored Contributor II

Re: Export//macro and IE Plugin ?

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

Re: Export//macro and IE Plugin ?

Thanks mwoolf, it is working.

What is the IE plugin for anyway ?

Community Browser