Microsoft vbscript runtime error object required

[nayanqlik]

Hi

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

[tamilarasu]

Hi Nayan,

Could you attach your log file here?

[nayanqlik]

Hi Tamil

As requested, see below.

Kind regards

Nayan

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

[kakani87]

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

City Lodge v5_CH988

[nayanqlik]

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>

[tamilarasu]

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

[nayanqlik]

Hi Tamil

Will do. Will send it once I reach work.

Kind regards

Nayan

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

[tamilarasu]

Hi Nayan,

Did u resolve the issue?

[nayanqlik · Accepted solution]

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

[tamilarasu]

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.