Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am just looking at building a script to reload a Qlikview App through VBScript. However I am getting an error when the script is doing CreateObject("QlikTech.QlikView"). The error code is 800700C1 and source is (null). Would anyone know why this is happening?
Thanks
I don't think you need to use "CreateObject" in order to reload a QlikView. If you need to reload the same document, you can simply use:
ActiveDocument.Reload
cheers,
Don't know about the error code, but the following works for me;
set Qv = CreateObject("QlikTech.QlikView")
Qv.OpenDoc "c:\customer\development\masterCalendar.qvw"
set QvDoc = Qv.ActiveDocument
QvDoc.ReloadEx 2,1
QvDoc.CloseDoc
Qv.Quit
Hi Blaise ,
I tried your code, it looks like reloading is happening as i can see document is opened & closed too.
But when i checked reloadtime() in target document , its not changed . What i understand is whenever we reload any document , reloadtime() will indicated latest updates .
Also , seek your niputs to understand what is " 2,1 " ????? in code "QvDoc.ReloadEx 2,1" ?
Any suggestions ?
Attaching both applications
Cheers,
Bhushan N
I am getting this error with the vbscript below.
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3581.Error-qvw-vbscript.doc:550:0]
I'm not sure if you checked it or not, but
in the module editor on the left lower side there are two comboBoxes
you must set the "Requested Module Security" to system access
and the "Current Local Security" to Allow System Access
they tell QV to allow the script to interact with the system (createObject)
Mansyno