Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

shashank20
New Contributor III

How to run macro through management console

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

3 Replies
Siva_Sankar
Honored Contributor

Re: How to run macro through management console

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

konstantin
Contributor III

Re: How to run macro through management console

post reload doesn't work on the server.

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

external.png

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

Re: How to run macro through management console

Community Browser