12 Replies Latest reply: Jan 31, 2013 3:30 PM by rich calligan RSS

Calling VBScript macro from loadscript

Arvind Mahapatar

Hello All,

 

I have created macro in Edit Module using VBScript.

 

Now I want to call the same macro from EditScript.

Is this possible and if yes how?

  • Re: Calling VBScript macro from loadscript
    Matan Alon

    Try this example:

     

    the script:

     

    T:
    LOAD * INLINE [
        F1
        1
        2
        3
        4
        5
    ];


    T2:
    load *,test(F1) as F2 resident T;

    drop table T

     

    the vbs  (macro):

     

     

    function test (x)

     

    test=x+1

     

    end function

    • Re: Calling VBScript macro from loadscript
      Arvind Mahapatar

      Hello Matan,

      Thanks for you reply.

       

      I tried above script. It gives error

      Error in expression:

      TEST is not a valid function

       

      T2:

      load *,test(F1) as F2 resident T

       

      See I will explain u d functionality i need to achieve.

      Basically after the qvw file gets reloaded, its PDF is to be created automatically for which i have written macro. I have set the action Run Macro on trigger OnPostReload and this works fine when I run the report on qlikview developer.

      But when the same report is reloaded through qlikview server it does not fire the trigger after completion of reload.

      I have also done the settings on server to allow macro execution. On qlikview community i found one more setting by pressing Ctrl+shift+m. I have also done that.

      In spite of all these things macro is not getting executed on server. So i was trying if macros can be executed through edit script. I am using Qlikview 11.00 SR1 version and I dont have publisher.

      Let me know if I have to do any other settings or anything else is required.

      Please help on this matter  ASAP. Its really very urgent.

      Thank u in advance.