Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
sorry forgot to mention,
Out side of Qlikview, i have this in an excel workbook
Yes, just replace the file name
Thanks!