topic Re: Microsoft vbscript runtime error object required in QlikView

Microsoft vbscript runtime error object required

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

I have a macro that automatically exports reports out of Qlikview into Excel. This model works perfectly fine for one client, however does not work for another. The error i get is "Microsoft vbscript runtime error object required" , when i look at the log file.

I've attached the macro.

Can you suggest what issue this could be and how should i solve it?

Kind regards

Nayan

Re: Microsoft vbscript runtime error object required

tamilarasu — Fri, 23 Feb 2018 19:07:29 GMT

Hi Nayan,

Could you attach your log file here?

Re: Microsoft vbscript runtime error object required

nayanqlik — Sat, 24 Feb 2018 04:16:55 GMT

Hi Tamil

As requested, see below.

Kind regards

Nayan

Get Outlook for Android<https://aka.ms/ghei36>

Re: Microsoft vbscript runtime error object required

kakani87 — Sat, 24 Feb 2018 04:38:10 GMT

Here in the log it is showing the below Object is missing Check this

City Lodge v5_CH988

Re: Microsoft vbscript runtime error object required

nayanqlik — Sat, 24 Feb 2018 04:45:43 GMT

Hi Kakani

Thank you for your reply. The object is there. When I use the same macro at another client of ours, it works.

Kind regards

Nayan

Get Outlook for Android<https://aka.ms/ghei36>

Re: Microsoft vbscript runtime error object required

tamilarasu — Mon, 26 Feb 2018 01:48:27 GMT

Nayan - It's bit hard to spot the issue by seeing only this snapshot. Is it possible to attach sample file?

Re: Microsoft vbscript runtime error object required

nayanqlik — Mon, 26 Feb 2018 05:02:41 GMT

Hi Tamil

Will do. Will send it once I reach work.

Kind regards

Nayan

Get Outlook for Android<https://aka.ms/ghei36>

Re: Microsoft vbscript runtime error object required

tamilarasu — Fri, 02 Mar 2018 15:26:08 GMT

Hi Nayan,

Did u resolve the issue?

Re: Microsoft vbscript runtime error object required

nayanqlik — Fri, 02 Mar 2018 15:30:41 GMT

Hi Tamil

Yes, the query was resolved. Our senior consultant assisted and picked up that it was a old version of Qlik and well as Qlik not installed on the C Drive.

Thank you for following up.

Kind regards

Nayan

Re: Microsoft vbscript runtime error object required

tamilarasu — Fri, 02 Mar 2018 15:38:31 GMT

Great. I thought you are not return to your work. Just kidding . I wanted to help you but glad that you solved it. Kindly mark your own response as correct and close this thread. Have a nice day and a nice weekend.

Re: Microsoft vbscript runtime error object required

nayanqlik — Fri, 02 Mar 2018 15:48:05 GMT

Hi Tamil

Hahaha. Will do.

Kind regards

Nayan

Get Outlook for Android<https://aka.ms/ghei36>