Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please help

hi

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

5 Replies
tresesco
MVP
MVP

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

Not applicable
Author

Hi,

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

christian77
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author

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.


Not applicable
Author

Hi,

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