topic Re: VBA Module - Quit Excel app in QlikView https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137480#M900812 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>try some thing like this.</P><P></P><P>objExcel = nothing</P><P>objExcel.Application = nothing</P><P></P><P>$@M.</P></BODY></HTML> Tue, 12 Jul 2016 09:19:08 GMT mightyqlikers 2016-07-12T09:19:08Z VBA Module - Quit Excel app https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137479#M900811 <HTML><HEAD></HEAD><BODY><P>Hy Qlikers,</P><P></P><P>i use a small macro in Qlik, but since i work on Office 2013 ,Excel doesn't close at the end.</P><P>Does someone meet the same issue ?</P><P>Thx for your help.</P><P></P><P>Set objExcel = CreateObject("Excel.Application")</P><P>....</P><P>...</P><P>objExcel.Quit</P><P>objExcel.Application.Quit </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137479#M900811 maxime66 2020-11-25T16:16:04Z Re: VBA Module - Quit Excel app https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137480#M900812 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>try some thing like this.</P><P></P><P>objExcel = nothing</P><P>objExcel.Application = nothing</P><P></P><P>$@M.</P></BODY></HTML> Tue, 12 Jul 2016 09:19:08 GMT https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137480#M900812 mightyqlikers 2016-07-12T09:19:08Z Re: VBA Module - Quit Excel app https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137481#M900813 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I've check in our macros and there is only one statement:</SPAN></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_146831555994473 jive_text_macro" jivemacro_uid="_146831555994473"> <P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">objExcel.Quit</SPAN></P> </PRE><P></P><P>After than goes the:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1468315593596495" jivemacro_uid="_1468315593596495"> <P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ActiveDocument.getApplication.sleep 5000</SPAN></P> </PRE><P></P><P>Nothing else.</P></BODY></HTML> Tue, 12 Jul 2016 09:26:50 GMT https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137481#M900813 MindaugasBacius 2016-07-12T09:26:50Z Re: VBA Module - Quit Excel app https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137482#M900814 <HTML><HEAD></HEAD><BODY><P>Works fine !</P><P>thanks</P></BODY></HTML> Tue, 12 Jul 2016 09:56:36 GMT https://community.qlik.com/t5/QlikView/VBA-Module-Quit-Excel-app/m-p/1137482#M900814 maxime66 2016-07-12T09:56:36Z