Releasing COM-Object not necessary

Question

Using _excel then equals New Excel. I'll use this if I don't use Excel. When I hit Quit and FinalReleaseComObject( excel), the excel process will also exit.

Nevertheless, if I utilise both cleanup techniques, the excel process will continue until my application is closed.

I'm utilising Visual Studio 22 and Windows 10

So, is it outdated to clean up uncontrolled resources?

Answer 1

This place has infamously poor Office COM interops. In general, you should get rid of everything in the reverse order of how it was made. As an illustration, suppose that after creating Excel.Application, you also have references to workbooks and sheets. If you call. If you quit without first deleting any worksheet references and closing the workbook, the process is retained in memory. You shouldn't need to call FinalReleaseComObject; in fact, if references are still held in memory after disposal, the process may or may not crash.

I hope this helps you.