Export//macro and IE Plugin ?

[#1]

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

[m_woolf · Accepted solution]

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.

[#3]

Thanks mwoolf, it is working.

What is the IE plugin for anyway ?