Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Desktop 11.2 - Ordering Sub Execution

Hello People,

I have two Subs in my "Edit Module":

Sub Reaload

ActiveDocument.Reload 0,1

End Sub

Sub Run_VBS

Set WshShell = CreateObject("WScript.Shell")

ActiveDocument.WshShell.Run chr(34) & "C:\TESTE.bat" & Chr(34), 0

Set WshShell = Nothing
End Sub

Both sub work fine however I want a specific rule in execution progress:

  • I've to guarantee that the Sub Run_VBS runs before that Sub Reload because the Sub Reaload depends on the success of the Sub Run_VBS.

I know that I've the ActiveDocument in firtst Sub but I've it to build the automation of the script.

How to achieve this?

Thank you very much!

1 Reply
Gysbert_Wassenaar

Sub Reaload

ActiveDocument.Reload 0,1

End Sub

Sub Run_VBS

Set WshShell = CreateObject("WScript.Shell")

ActiveDocument.WshShell.Run chr(34) & "C:\TESTE.bat" & Chr(34), 0

Set WshShell = Nothing
End Sub


Sub RunThisOneInstead

    Reaload()

    Run_VBS()

End Sub


talk is cheap, supply exceeds demand