topic Re: Please help in QlikView

Please help

Thu, 26 Sep 2013 05:52:11 GMT

I want to run MAcro Through .vbs file

It includes

Opening QVW file

Macro execution(Through Btn click)

Closing QVW Doc.

The Problem here is.

.Vbs file Execution does not wait for QVW MACRO Execution.

It moves to next code line and closes the QVW file.

I want .VBS file to wait for MACRO execution .. for tht I tried

ActiveDocument.GetApplication.WaitForIdeal

But its not supporting..

Pls help.

Regards

Avadhoot

tresB — Thu, 26 Sep 2013 06:57:29 GMT

Have a look at this discussion which might give you some idea.

Thu, 26 Sep 2013 07:24:11 GMT

Hi,

Try to close the document in macro itself. so it will close after the macro executes using doc.CloseDoc.

christian77 — Thu, 26 Sep 2013 08:13:02 GMT

Hi:

There is a clause in VB wait 10000 seconds, in miliseconds. That would be 10 seconds.

Get the API Guide 11 to program macros.

Good luck.

Fri, 27 Sep 2013 04:08:34 GMT

Hi Sindhu

thnx

But I have written Macro in Qlikview

and using .Vbs files i want to run tht macro...

Since In qliview that macro exe. on Btn click

so i wrote Btn.Press command in vbs.

Bt .Vbs does not waits for Tht macro it goes ahead and closes the doc.

Fri, 27 Sep 2013 05:07:08 GMT

Hi,

Are you closing the document in .vbs? If yes, remove that code and try to close the document in macro only.