How to run macro through management console

[Anonymous]

Hi Geniuses,

I have a macro which on the document reload is having a capability of taking the data of few of the straight tables load it into the excel save the excel and close the document.

when i am reloading the document on the client side that is when i am doing development its working fine

but when i reload the task through management console its not working

I know that u cant run a macro from console

but can anyone tell me the workaround to acheive this

your help is highly appreciated

Thanks,

Shashank

[Siva_Sankar]

Hi Shashank,

Are you using  OnPostReload in your qvw file?. If that is the case then qmc wont run macros in OnPostReload from server.

You can create a batch file to achieve this functionality. Find the document in the URL helping you to achieve the same.

Automated Excel Export and Email Macro

[Anonymous]

post reload doesn't work on the server.

You can add button to run macro for example, or add External task

in the command line statement you need to point vbs file location.

Some additional works must be done with vbs - open qvw file in the macros

[ashfaq_haseeb]

Hi,

You have to look at EDX .

have a look at below link.

http://community.qlik.com/docs/DOC-2650

http://community.qlik.com/docs/DOC-5111

http://community.qlik.com/docs/DOC-3024

Regards

ASHFAQ