topic Re: Macro help... in QlikView https://community.qlik.com/t5/QlikView/Macro-help/m-p/731905#M262111 <HTML><HEAD></HEAD><BODY><P>when i hide the sheet and run through .bat file&nbsp; its not working(no mail received). Is there any way so that I can hide that sheet and can receive mails.</P></BODY></HTML> Wed, 23 Jul 2014 10:48:53 GMT 2014-07-23T10:48:53Z Macro help... https://community.qlik.com/t5/QlikView/Macro-help/m-p/731902#M262108 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have written a macro for sending mails on reload of an app, in this i have to send tables in one sheet whereas this sheet should be hidden in main app. So how can i get to run a macro and get the mails from that sheet which i will hide in that app.</P><P></P><P>Kindly suggest any other better way, if any.</P><P></P><P>Regards</P></BODY></HTML> Wed, 23 Jul 2014 09:23:51 GMT https://community.qlik.com/t5/QlikView/Macro-help/m-p/731902#M262108 2014-07-23T09:23:51Z Re: Macro help... https://community.qlik.com/t5/QlikView/Macro-help/m-p/731903#M262109 <HTML><HEAD></HEAD><BODY><P>Dear Rajeshree,</P><P></P><P>Please share a sample file.</P><P></P><P></P><P>Kind regards,</P><P>Ishfaque Ahmed</P></BODY></HTML> Wed, 23 Jul 2014 09:25:26 GMT https://community.qlik.com/t5/QlikView/Macro-help/m-p/731903#M262109 engishfaque 2014-07-23T09:25:26Z Re: Macro help... https://community.qlik.com/t5/QlikView/Macro-help/m-p/731904#M262110 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">The only way to do it is with a .bat file. Publisher or the Server reloads do not executive any macros.</SPAN></P></BODY></HTML> Wed, 23 Jul 2014 10:10:32 GMT https://community.qlik.com/t5/QlikView/Macro-help/m-p/731904#M262110 m_woolf 2014-07-23T10:10:32Z Re: Macro help... https://community.qlik.com/t5/QlikView/Macro-help/m-p/731905#M262111 <HTML><HEAD></HEAD><BODY><P>when i hide the sheet and run through .bat file&nbsp; its not working(no mail received). Is there any way so that I can hide that sheet and can receive mails.</P></BODY></HTML> Wed, 23 Jul 2014 10:48:53 GMT https://community.qlik.com/t5/QlikView/Macro-help/m-p/731905#M262111 2014-07-23T10:48:53Z Re: Macro help... https://community.qlik.com/t5/QlikView/Macro-help/m-p/731906#M262112 <HTML><HEAD></HEAD><BODY><P>Does it work when you run it in the client?</P><P>If so, it should work in the batch file.</P><P>If it doesn't work because the sheet is hidden, you can always unhide the sheet in the macro and then hide again at the end.</P></BODY></HTML> Wed, 23 Jul 2014 10:51:09 GMT https://community.qlik.com/t5/QlikView/Macro-help/m-p/731906#M262112 m_woolf 2014-07-23T10:51:09Z Re: Macro help... https://community.qlik.com/t5/QlikView/Macro-help/m-p/731907#M262113 <HTML><HEAD></HEAD><BODY><P>can u please share the command to undide the sheet in the macro and then hide again at the end?</P></BODY></HTML> Wed, 23 Jul 2014 10:52:56 GMT https://community.qlik.com/t5/QlikView/Macro-help/m-p/731907#M262113 2014-07-23T10:52:56Z Re: Macro help... https://community.qlik.com/t5/QlikView/Macro-help/m-p/731908#M262114 <HTML><HEAD></HEAD><BODY><P>Conditionally show the sheet with a variable.</P><P>The macro will change the value of the variable.</P></BODY></HTML> Wed, 23 Jul 2014 10:56:23 GMT https://community.qlik.com/t5/QlikView/Macro-help/m-p/731908#M262114 m_woolf 2014-07-23T10:56:23Z