topic Re: Calling VB Script macro from Qlik edit script in QlikView

Calling VB Script macro from Qlik edit script

muthukumarbalu — Wed, 14 Nov 2018 03:57:48 GMT

Hi Team,

I Have VB Script macro which writes table objects data into excel file once the reload completes by Post reload trigger. This works fine in desktop version, When i set up it in access point, post reload trigger is not working. So planned to call the vb script macro at end of load script with below syntax,

Let Vcall= Generatereport();

But this is not working as advised in Qlik community. Hence, Please advise me how to fix this.

Thanks in advance.

Best Regards,

Re: Calling VB Script macro from Qlik edit script

Anil_Babu_Samineni — Wed, 14 Nov 2018 05:22:47 GMT

Either you can use one of the below

1. EDX Triggers

2. Create Button to active that macro from Module in Qlik.

Re: Calling VB Script macro from Qlik edit script

muthukumarbalu — Wed, 14 Nov 2018 06:48:51 GMT

Hi,

Please advise how to implement with 2nd option. thanks

Re: Calling VB Script macro from Qlik edit script

Anil_Babu_Samineni — Wed, 14 Nov 2018 08:10:52 GMT

Sure - Which Browser you are using? Check diff What is the diff Ajax / IE Browser

Re: Calling VB Script macro from Qlik edit script

muthukumarbalu — Wed, 14 Nov 2018 08:38:41 GMT

Chrome broweser