topic Re: Export by Macro in QlikView https://community.qlik.com/t5/QlikView/Export-by-Macro/m-p/955083#M965231 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>chk dis</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4870">Useful Qlikview Macros</A></P></BODY></HTML> Tue, 09 Feb 2016 06:46:52 GMT Chanty4u 2016-02-09T06:46:52Z Export by Macro https://community.qlik.com/t5/QlikView/Export-by-Macro/m-p/955082#M965229 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have created a macro that exports multiple objects to a single excel workbook.</P><P>However whenever the macro executes, all objects gets opened (if minimized) and maximized. How can I prevent this from happening?</P><P></P><P>I want to be able to export without any object opening up first.</P></BODY></HTML> Mon, 12 Oct 2015 08:16:55 GMT https://community.qlik.com/t5/QlikView/Export-by-Macro/m-p/955082#M965229 2015-10-12T08:16:55Z Re: Export by Macro https://community.qlik.com/t5/QlikView/Export-by-Macro/m-p/955083#M965231 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>chk dis</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4870">Useful Qlikview Macros</A></P></BODY></HTML> Tue, 09 Feb 2016 06:46:52 GMT https://community.qlik.com/t5/QlikView/Export-by-Macro/m-p/955083#M965231 Chanty4u 2016-02-09T06:46:52Z Re: Export by Macro https://community.qlik.com/t5/QlikView/Export-by-Macro/m-p/955084#M965232 <HTML><HEAD></HEAD><BODY><P>Comment out these two lines:</P><P></P><P>set objSource = qvDoc.GetSheetObject(qvObjectId)</P><P><STRONG>'Call objSource.GetSheet().Activate()</STRONG></P><P><STRONG>'objSource.Maximize</STRONG></P><P>qvDoc.GetApplication.WaitForIdle</P></BODY></HTML> Tue, 09 Feb 2016 06:59:12 GMT https://community.qlik.com/t5/QlikView/Export-by-Macro/m-p/955084#M965232 jonathandienst 2016-02-09T06:59:12Z