topic OpenDoc not able to open document in QMC in QlikView

OpenDoc not able to open document in QMC

bennywoo — Wed, 25 Nov 2020 16:16:04 GMT

I have a vbscript as below to open a QVW file.

set objQv = CreateObject("QlikTech.Qlikview")

set objQvDoc = objQv.OpenDoc("d:\test.qvw","","")

objQvDoc.reloadEx 0,1

objQvDoc.CloseDoc

objQv.Quit

The script can be run successfully from the Server DOS command prompt.

But if I schedule it to run in the QMC. I got the following error

Microsoft VBScript runtime error: Object required: 'objQvDoc'

Can someone help on this ?

Re: OpenDoc not able to open document in QMC

Miguel_Angel_Baeyens — Thu, 14 Jun 2018 07:10:39 GMT

You cannot run these types of macros when using QMC, the ones that use ActiveX objects or refer to them or properties.

Re: OpenDoc not able to open document in QMC

bennywoo — Wed, 27 Jun 2018 05:06:25 GMT

I found the solution. The original qvw file was created in the test server. So I created a another qvw in the production server and copy everything from the original qvw, then the QMC can call the vbscript to execute the qvw successfully.