Sub in a macro

[#1]

Hi, i Have a Sub in a Macro and i want to execute them as i reload my application.

well, i was searching and found the comand "call", i tried it but it's not working. I think that is cause is in a macro.

someone can help me?

Thank you.

[luciancotea]

Call VBA macro function from the load script | Lucian Cotea

[tresesco]

If your macro returns a value, you can call that in the script like:

Let vGetFromMacro = YourMacroName();

Remember, you can't access UI object from script.

[#4]

in my case, my sub don't return anything, but thank you 

i  have a sub that do a report and send a e-mail to some people. I have the sub script, but it's not working yet

[sivarajs]

Guess you cant directly call sub in qlikview script. You can define sub in function then you can call like above method

[Peter_Cammaert]

Why not use a Document trigger called OnPostReload (see Settings->Document Properties->Triggers->Document Event Triggers)? That trigger will fire immediately after you do a document reload every time.

If you attach an action to this trigger like External->Run Macro and point that action to the macro Sub you already created, you get a more reliable result. Even works in a QVS environment.

See if that fits your requirements.

Best,

Peter

[luciancotea]

Peter, OnPostReload does not work in QVS.

The following triggers are not to be used in the QlikView Server environment, since they lack meaning or may cause unexpected results:

OnPostReduceData

OnPostReload

"QlikView reference manual"

[Peter_Cammaert]

Oh great. Probably been working on OCX models for too long. And even there, triggers don't always work reliably it seems.

Thanks for the reminder.

Peter