Force close Script Execution Progress window after reload

[luke1986]

Hello,

We have an application which the server reloads with a batch as soon as a trigger execute it.

(qv.exe /R C:\Qlikview\blabla.qvw)

This works fine as long as the Option:  "close Script Execution Progress window after reload" is ticked off.

Strangely, this Option seems to reset quite often and the batch then fails or run in a loop.

Is there an a way to force close this window no matter what? Maybe with vbs or Macro?

Thanks Lukas

[vinieme12 · Accepted solution]

try like below

Check reference Qlikview XX.xx type library

sub reloadqvw()

Dim App As New QlikView.Application

Dim Doc As New QlikView.Document

Set Doc = App.OpenDoc(<<Filename.QVW>>, "", "")

Doc.Activate

            Doc.ReloadEx 0, 0

            Doc.Save

            Doc.CloseDoc

End Sub

[luke1986]

Hello Vineeth,

Do i have to run this in the Qlikview Macro Editor or outside as a vbs script?

Replacing the Filename.qvw with the name of the application, is that all or do i need to do something else?

Lukas

[vinieme12]

sorry forgot to mention,

Out side of Qlikview, i have this in an excel workbook

Yes, just replace the file name

[luke1986]

Thanks!