Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm having issues running a VBS script from the commandline which reloads a .qvw file. I need it to leave the current window alone and open a "background" thread version of QV.exe. Does anyone know how to do this?
Here's a sample of the code I'm using in my .vbs file:
Option Explicit
Dim qlikapp
Dim qlikdoc
Set qlikapp = CreateObject("QlikTech.QlikView")
Set qlikdoc = qlikapp.OpenDocEx("Y:\BI\DEV Space\DailyPLSO.qvw", 0, False)
qlikdoc.ReloadEx 2,1 ' 2=ignore Errors; 1=hide process dialog
qlikdoc.save
qlikdoc.CloseDoc
'qlikapp.Quit
Set qlikapp = Nothing
set qlikdoc = Nothing
I've even tried a method of calling it from an AccessDB using vba:
Private Sub RefreshQVW_Click()
Dim App As New QlikView.Application
Dim Doc As QlikView.Document
Set Doc = App.OpenDocex("Y:\BI\DailyPLSO.qvw", 0, False, "", "", "", False)
With Doc
.ReloadEx 2, 1
.Save
.CloseDoc
End With
Set App = Nothing
Set Doc = Nothing
End Sub
Hi Michael,
Have you found a solution to your problem ?
I've got the same issue trying to create a stress test vbscript for QlikView.
Best Regards
Stéphane.