Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting Error in vbScript

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

5 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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,

blaise
Partner - Specialist
Partner - Specialist

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




Not applicable
Author

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

Not applicable
Author

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]

wizardo
Creator III
Creator III

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