run a macro after reload

[hopkinsc]

hi all,

I have a macro that emails out a QV report. the macro runs fine if i run it manually from the desktop client but i need a way to run it automatically after a reload has finished.

On post reload doesnt work for this, does anyone have any suggestions please?

I don't mind if its a windows scheduled task that runs at a specific time, i just don't know how to get a script to open the QV doc and run the macro.

Thanks

[m_woolf]

You will need to set up an external task and reload the qvw with a batch file.

Run a macro on post reload

[vikasmahajan]

On Post Reaload you can run the macro.

Vikas

[ashfaq_haseeb]

Hi,

Check this

http://community.qlik.com/thread/15988

regards

ASHFAQ

[hopkinsc]

thanks for the replies so far.

my client does not have publisher which is why i had to use a macro to create and email the report.

i know have a batch file that reloads the qvw and runs the macro (as a result of the on post reload trigger).

the problem i am getting now is that the macro doesnt finish running. it creates the report and saves it in the correct location but nothing is done after it (so nothing is emailed out) and the cmd window hangs.

it works perfectly if i open up the qvw and manually reload but i need this to be automated.

[m_woolf]

The cmd window probably hangs because the macro doesn't quit the application.

ActiveDocument.save      Activedocument.Getapplication.quit

When this is working in the client, what causes the emails to be sent?