Vbs

[#1]

Hi everyone,

I am trying to create a ppt file from qlikdashboard usind vb script in the action tab. In qlik desktop version .

When ever i click the macro button my qlikfile is going into not responding mode.

I tried  a simple create object function to open ppt.

I have given the mode as system access and still not able to execute the script.

Can someone please help me in fixing this issue.

Thanks in advance

[m_woolf]

Please post your vbscript, or even better, a sample qvw.

[trdandamudi]

Hope the below link will help:

https://community.qlik.com/thread/200429

[#4]

Sub ExportPPT 

Set objPPT = CreateObject("PowerPoint.Application") 

objPPT.Visible = True

End sub

This is a simple script which is used to open an empty ppt file.  When i run this my qlikfile is not responding.

[trdandamudi]

Your code does work on my side. It opens a blank power point...

[#6]

Hi Tirumala,

Thats the problem i am facing.  This code is working for many people.  If i run this my application is hanging. I want to know if i have to do some pre requirements check before running this.

[m_woolf]

A standard method of finding the error is to place msgboxes between the lines of code, something like this:

Sub ExportPPT

     msgbox "1"

     Set objPPT = CreateObject("PowerPoint.Application")

     msgbox "2"

     objPPT.Visible = True

     msgbox "3"

End sub

When you run the macro, if you see msgbox "1" and not msgbox "2", you know the problem is with the CreateObject line.

If you see msgbox "2" and not msgbox "3", you know the problem is with the .Visible line.

Since this code is not Qlikview specific, you can create a .vbs file and run it outside of QlikView. I presume it will fail in the same manner. If the problem is not in QlikView, then you start looking at your installation of Microsoft Office.

[trdandamudi]

I don't think there is any pre requirement.. Can you try the below link and let us know:

https://community.qlik.com/thread/200429