how to call macro in a loading script ?

[#1]

hi,

Qlikview Document edit module,maro code:

sub kk

....

end sub

how to call macro in a loading script ? is it possible to execute a macro?

Thanks in advance & best regards

[#2]

First of all, you need create the Macro in Edit Module with Function FNAME()... End Function

So you can this function in script.

[#3]

Hi Xiao,

After you have written script in the edit module part, then you need to call that macro on the open event of application.

In this case the macro name is 'kk'...

Goto Settings tab

Goto Triggers tab

Under Document Event Triggers, click on 'On Open'

Now click on Add Actions tab

select External as action type

Select Run Macro as action

Give the name as kk(as per the macro you had created in the attached qvw file )

Click on apply.

Now save the qvw and open again  And now you will find Macro Running...statement visible on the bottom left hand side when you open the application..

I hope it helps

[juan_c_martinez]

This works fine! Thaks it helps me!

Juan