topic Excel cant close without saving in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/excel-cant-close-without-saving/m-p/4806946#M1125306 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I am using an Excel macro to execute a special calculus. So Iu2019m creating an Excel and a macro and executing it to get the return value.</P><P>The problem is when I finish the program I free all objects by:</P><P></P><P>CALL METHOD OF h_excel 'QUIT'.</P><P>FREE OBJECT book_font.</P><P>FREE OBJECT p_val.</P><P>FREE OBJECT cell.</P><P>FREE OBJECT this_workbook.</P><P>FREE OBJECT workbooks.</P><P>FREE OBJECT newmodule.</P><P>FREE OBJECT module.</P><P>FREE OBJECT h_excel. "free up memory</P><P></P><P>and I get a pop up asking if I want to save the Excel Iu2019ve created.</P><P></P><P>I added this lines to deactivate the macro, and I stopped having the pop up but I still have an Excel process on the task manager</P><P></P><P>CALL METHOD OF newmodule 'Desactivate'.</P><P>CALL METHOD OF module 'Desactivate'.</P><P></P><P></P><P></P><P>Am I missing something?</P><P></P><P></P><P>Thanks in advance,</P><P></P><P>Best Regards</P></BODY></HTML> Wed, 03 Dec 2008 15:37:12 GMT Former Member 2008-12-03T15:37:12Z Excel cant close without saving https://community.sap.com/t5/application-development-and-automation-discussions/excel-cant-close-without-saving/m-p/4806946#M1125306 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I am using an Excel macro to execute a special calculus. So Iu2019m creating an Excel and a macro and executing it to get the return value.</P><P>The problem is when I finish the program I free all objects by:</P><P></P><P>CALL METHOD OF h_excel 'QUIT'.</P><P>FREE OBJECT book_font.</P><P>FREE OBJECT p_val.</P><P>FREE OBJECT cell.</P><P>FREE OBJECT this_workbook.</P><P>FREE OBJECT workbooks.</P><P>FREE OBJECT newmodule.</P><P>FREE OBJECT module.</P><P>FREE OBJECT h_excel. "free up memory</P><P></P><P>and I get a pop up asking if I want to save the Excel Iu2019ve created.</P><P></P><P>I added this lines to deactivate the macro, and I stopped having the pop up but I still have an Excel process on the task manager</P><P></P><P>CALL METHOD OF newmodule 'Desactivate'.</P><P>CALL METHOD OF module 'Desactivate'.</P><P></P><P></P><P></P><P>Am I missing something?</P><P></P><P></P><P>Thanks in advance,</P><P></P><P>Best Regards</P></BODY></HTML> Wed, 03 Dec 2008 15:37:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-cant-close-without-saving/m-p/4806946#M1125306 Former Member 2008-12-03T15:37:12Z Re: Excel cant close without saving https://community.sap.com/t5/application-development-and-automation-discussions/excel-cant-close-without-saving/m-p/4806947#M1125307 <HTML><HEAD></HEAD><BODY><P>Problem solved.</P><P>I had to set the Excel property DisplayAlerts = 0.</P></BODY></HTML> Thu, 04 Dec 2008 13:05:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-cant-close-without-saving/m-p/4806947#M1125307 Former Member 2008-12-04T13:05:09Z