topic Getting Error in vbScript in QlikView

Getting Error in vbScript

Thu, 11 Mar 2010 21:43:46 GMT

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

Getting Error in vbScript

Oleg_Troyansky — Thu, 11 Mar 2010 22:11:13 GMT

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,

Getting Error in vbScript

blaise — Thu, 11 Mar 2010 23:46:18 GMT

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

Getting Error in vbScript

Fri, 12 Mar 2010 06:33:47 GMT

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

Getting Error in vbScript

Fri, 12 Mar 2010 14:18:45 GMT

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]

Getting Error in vbScript

wizardo — Sat, 13 Mar 2010 00:18:25 GMT

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