topic Re: Error with export to power point 2007 in QlikView

Error with export to power point 2007

Anonymous — Fri, 26 Feb 2016 14:01:13 GMT

Dear colleagues, good day!

I'm trying to export data to Power Point (MS Office 2007). I have simple code, which must only open ppt document:

Sub ExportPPT()

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

But this macro not working (any reaction when i run it)

Maybe, there are some features with exporting to ppt 2007?

Thanks.

m_woolf — Fri, 26 Feb 2016 14:50:45 GMT

The macro works fine for me.

Do you have Macro Security set to System Access?

Are you trying to run the macro from the accesspoint?

If yes, are you using IE and the QV Plugin?

Anonymous — Fri, 26 Feb 2016 20:35:28 GMT

I try to run macro on server.

When i run it as accesspoint, it works fine...