Skip to Content
0
Former Member
Dec 03, 2008 at 03:37 PM

Excel cant close without saving

37 Views

Hello all,

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.

The problem is when I finish the program I free all objects by:

CALL METHOD OF h_excel 'QUIT'.

FREE OBJECT book_font.

FREE OBJECT p_val.

FREE OBJECT cell.

FREE OBJECT this_workbook.

FREE OBJECT workbooks.

FREE OBJECT newmodule.

FREE OBJECT module.

FREE OBJECT h_excel. "free up memory

and I get a pop up asking if I want to save the Excel Iu2019ve created.

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

CALL METHOD OF newmodule 'Desactivate'.

CALL METHOD OF module 'Desactivate'.

Am I missing something?

Thanks in advance,

Best Regards