Discussion Board for collaboration on QlikView Publisher.
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
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
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
You have to look at EDX .
have a look at below link.