topic Re: VB Script Error : Object Required in QlikView

VB Script Error : Object Required

er_mohit — Thu, 17 Dec 2015 07:31:34 GMT

Hi All,

I have tried lots of stuff to sort out vb script issue while run macro code thorugh batch file but can't get success.

Given below my macro code.

set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc("F:\QlikView\Dev\testdata.qvw","","")

Set ActiveDocument = MyDoc

ActiveDocument.Reload

Set Button1 = ActiveDocument.GetSheetObject("BU01")

Button1.Press

WScript.Sleep(100000)

MyDoc.GetApplication.Quit

Set MyDoc = Nothing

Set MyApp = Nothing

When i run through qlikview it works perfectly but the same not work through .vbs file. When i run the batch file it gives an error.

Please find attached the error screenshot.

Any help will be appreciable.

Regards

Mohit

Re: VB Script Error : Object Required

marcus_sommer — Thu, 17 Dec 2015 07:37:05 GMT

Try:

set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc("F:\QlikView\Dev\testdata.qvw","","")

MyDoc.Reload

Set Button1 = ActiveDocument.GetSheetObject("BU01")

Button1.Press

WScript.Sleep(100000)

MyDoc.GetApplication.Quit

Set MyDoc = Nothing

Set MyApp = Nothing

- Marcus

Re: VB Script Error : Object Required

tamilarasu — Thu, 17 Dec 2015 07:37:19 GMT

Try,

Sub er()

set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc("C:\Users\Tamilarasu.Nagaraj\Desktop\New folder (2)\Test_Sowmya - Copy.qvw","","")

MyDoc.Reload

Set Button1 = ActiveDocument.GetSheetObject("BU01")

Button1.Press

WScript.Sleep(100000)

MyDoc.GetApplication.Quit

Set MyDoc = Nothing

Set MyApp = Nothing

End Sub

Re: VB Script Error : Object Required

er_mohit — Thu, 17 Dec 2015 07:45:55 GMT

Hi Marcus_Sommer‌,

Thanks for reply. I have tried the same but getting an error.

PFA the error scrrenshot.

Re: VB Script Error : Object Required

marcus_sommer — Thu, 17 Dec 2015 07:52:50 GMT

It seems that the file-path isn't correct or that the proper access rights are missing. This can happen if you executed the batch from another machine (you might need to use unc-paths or to mount this drive) or another user-account.

- Marcus

Re: VB Script Error : Object Required

tamilarasu — Thu, 17 Dec 2015 07:59:31 GMT

Try to run the same code for an another application and see.

Re: VB Script Error : Object Required

er_mohit — Thu, 17 Dec 2015 08:24:29 GMT

Hi,

I have tried the same for other application but can't get success.

Re: VB Script Error : Object Required

tamilarasu — Thu, 17 Dec 2015 08:40:10 GMT

Not sure, Check the below link

Vbscript error when trying to reload and export