Export//macro and IE Plugin ?

Mon, 06 Aug 2012 07:52:02 GMT

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

Re: Export//macro and IE Plugin ?

m_woolf — Mon, 06 Aug 2012 10:36:15 GMT

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.

Tue, 07 Aug 2012 04:00:46 GMT

Thanks mwoolf, it is working.

What is the IE plugin for anyway ?