topic Re: QlikView VBS Error Objectrequired:ActiveDocument in QlikView

QlikView VBS Error Objectrequired:ActiveDocument

james — Sun, 09 Nov 2014 21:10:46 GMT

All, anyone know why I am getting "Object Required:ActiveDocument...If I restart the PC, it runs once fine...

Set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc ("c:\Test.qvw","","")

Set ActiveDocument = MyDoc

ActiveDocument.GetSheetObject("BU1").Press

MyDoc.CloseDoc

Set MyDoc = Nothing

MyApp.Quit

Set MyApp = Nothing

Re: QlikView VBS Error Objectrequired:ActiveDocument

michael_anthony — Mon, 10 Nov 2014 02:50:38 GMT

I'd suggest putting myApp.ActiveDocument.GetSheet.... the interpreter may not know which application your referring to with your ActiveDocument statement.

I'm not sure you using the ActiveDocument as intended though, why not skip that part and just refer to myDoc.GetSheetObject(....)

Re: QlikView VBS Error Objectrequired:ActiveDocument

jagan — Mon, 10 Nov 2014 03:15:02 GMT

Hi,

Try this

Set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc ("c:\Test.qvw","","")

Set currentDocument = MyDoc

currentDocument.GetSheetObject("BU1").Press

MyDoc.CloseDoc

Set MyDoc = Nothing

MyApp.Quit

Set MyApp = Nothing

Set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc ("c:\Test.qvw","","")

MyDoc.ActiveDocument.GetSheetObject("BU1").Press

MyDoc.CloseDoc

Set MyDoc = Nothing

MyApp.Quit

Set MyApp = Nothing

Regards,

Jagan.

Re: QlikView VBS Error Objectrequired:ActiveDocument

james — Mon, 10 Nov 2014 04:41:20 GMT

It works once than the 2nd try it renders the same message .

Re: QlikView VBS Error Objectrequired:ActiveDocument

james — Mon, 10 Nov 2014 18:07:20 GMT

Anyone? anyone?

Re: QlikView VBS Error Objectrequired:ActiveDocument

michael_anthony — Tue, 11 Nov 2014 00:19:45 GMT

what does the BU1 do when you press it? perhaps the action it triggers is compromising your environment and leaving something open.