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

[tresesco]

Try like:

LET vVar= kk();

[#3]

hi

LET vVar= kk();  is not working

[jagan]

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:

1. LET CreateFolder = CreateFolder(); 

Regards,

Jagan.

[tresesco]

Could you post your sample app that demonstrates the issue?

[luciancotea]

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.

[#7]

hi

See attached

[luciancotea]

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)

[#9]

hi

See attached

[tresesco]

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.