topic PptObject.Visible = False ---not working in macro in QlikView

PptObject.Visible = False ---not working in macro

sarathi_pm — Mon, 17 Mar 2014 16:38:04 GMT

Hi,

I am working on a project where i am exporting the Qlikview charts into powerpoint slides. The code works the way i want. But the problem is the Powerpoint window is kept open when the qlikview macro writes the data to powerpoint. I want the powerpoint to be invisible so that the user doesnt see the slides getting generated.

I tried setting the powerpoint object visible = false, but the code fails in that line.

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = False ' Code fails here

Does anyone have any workaround or a method in which the powerpoint is hidden when the whole macro is running?

Thanks

Sarathi

Re: PptObject.Visible = False ---not working in macro

m_woolf — Mon, 17 Mar 2014 19:46:00 GMT

I see on the web that you can't set PPT to visible=false and then select things.

The article says that you can open PPT without a window, though.

vbscript - How can I programmatically open Powerpoint without seeing the window? - Stack Overflow

Re: PptObject.Visible = False ---not working in macro

sarathi_pm — Tue, 18 Mar 2014 05:46:18 GMT

Thanks for the link Michael Woolf. It helped.

Now i am not able to see the powerpoint window opened. But i am facing another issue.

My code loops through the powerpoint slides and opens the chart data (the excel behind the chart) and updates the data in the excel.

After implementing what you have suggested, the powerpoint window is invisible, but the excel window pops up .

Any idea how to suppress the excel window to be invisible?

Thanks

Sarathi