Run Macro after reload in QV Server

[Anonymous]

Hi, I have macro to export straight table to excel.

I've testing manual to run that macro and it's successful  create excel file.

I need that file excel daily, so how to run automatically macro after qvd files succeed reload in QVS

[Siva_Sankar]

Hi Yislam,

Setting-->Document Property-->Trigger-->Select On Post Reload-->Click on Add Button on right side

then add Action as Run Macro --> MacroName.

In server, sometimesOnPostReload event is not fired after a server reload. You will need to use a batch load using QV desktop to perform the reload.

-Siva

[Anonymous]

Hi Siva,

You mean I must reload again using a batch? Can you give me another option

Btw syntax to reload like this below:

"C:\Program Files\QlikView\Qv.exe" /r "E:\Data\Small_test.qvw" 

[marcus_sommer]

A reload from the qmc is executed from the qvb.exe which don't execute any macros because it updates just the data and didn't load the UI features. The meant you will need some kind of batch-execution but you could trigger them through the qmc with an EXECUTE statement - here one example as a starting point: Re: How can I run a macro on QMC after reload?

- Marcus