topic Re: how to call macro in a loading script ? in QlikView

how to call macro in a loading script ?

Wed, 18 Dec 2013 06:15:02 GMT

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

Re: how to call macro in a loading script ?

tresB — Wed, 18 Dec 2013 06:18:51 GMT

Try like:

LET vVar= kk();

Re: how to call macro in a loading script ?

Wed, 18 Dec 2013 06:22:15 GMT

LET vVar= kk(); is not working

Re: how to call macro in a loading script ?

jagan — Wed, 18 Dec 2013 06:25:18 GMT

Hi,

Check this URLs

Execute a Macro inside load script

Example Macro:

Function CreateFolder()

Dim objFSO

Set objFSO = CreateObject("Scripting.FileSystemObject")

objFSO.CreateFolder("C:\MacroTestFolder")

End Function

QlikView Load Script:

LET CreateFolder = CreateFolder();

Regards,

Jagan.

Re: how to call macro in a loading script ?

tresB — Wed, 18 Dec 2013 06:27:31 GMT

Could you post your sample app that demonstrates the issue?

Re: how to call macro in a loading script ?

luciancotea — Wed, 18 Dec 2013 06:35:16 GMT

See Jagan's example.

Be aware that you cannot access interface elements at LOAD SCRIPT time. For example, if you want to export a chart, it will not work.

Re: Re: how to call macro in a loading script ?

Wed, 18 Dec 2013 06:36:03 GMT

See attached

Re: how to call macro in a loading script ?

luciancotea — Wed, 18 Dec 2013 06:42:23 GMT

You can't access interface objects at LOAD SCRIPT time. You have to call your macro using a trigger after the script is run (like OnPostReload trigger)

Re: Re: how to call macro in a loading script ?

Wed, 18 Dec 2013 06:44:20 GMT

See attached

Re: how to call macro in a loading script ?

tresB — Wed, 18 Dec 2013 07:08:28 GMT

As said by Lucian Cotea, you can't access UI object at load script. While you call a macro in the script, it is expected that the macro function would return a value whic is not the case with your macro.

Re: how to call macro in a loading script ?

Wed, 18 Dec 2013 14:17:49 GMT

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

So you can this function in script.

Re: how to call macro in a loading script ?

Wed, 18 Dec 2013 14:37:42 GMT

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

Re: how to call macro in a loading script ?

juan_c_martinez — Thu, 03 Apr 2014 08:56:30 GMT

This works fine! Thaks it helps me!

Juan