VB.NET Excel Program Leaves EXCEL.EXE floating after completion

by

Below is code that works for me (NOTE order that I release objects, which is important)

xlWorkBook.Close()
xlApp.Quit()
ReleaseObject(xlWorkSheet)
ReleaseObject(xlWorkBook)
ReleaseObject(xlApp)

Private Sub ReleaseObject(ByVal obj As Object)
  Try
    System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
    obj = Nothing
  Catch ex As Exception
    obj = Nothing
  Finally
    GC.Collect()
  End Try
End Sub

More Related Contents:

  1. Clean up Excel Interop Objects with IDisposable
  2. The proper way to dispose Excel com object using VB.NET?
  3. How to count the number of rows in excel with data?
  4. VB.Net – Excel COM Object not getting released [duplicate]
  5. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  6. Reference variables and objects elsewhere in a form
  7. Parse Delimited CSV in .NET
  8. Using related data stored in a 2 dimensional array
  9. Is the Microsoft.VisualBasic namespace “true .NET” code?
  10. How do you get a string from a MemoryStream?
  11. How do I convert an Excel serial date number to a .NET DateTime?
  12. Which is generally best to use — StringComparison.OrdinalIgnoreCase or StringComparison.InvariantCultureIgnoreCase?
  13. How do I create an event handler for a programmatically created object in VB.NET?
  14. Does End Using close an open SQL Connection
  15. Does this code prevent SQL injection?
  16. Option Strict On and .NET for VB6 programmers
  17. How to print datagridview table with its header in vb.net?
  18. How to draw a signature and save it to disc as a Bitmap?
  19. How to convert date format in vb.net?
  20. Form’s TransparencyKey leaves ghastly colored edging [closed]
  21. Redirect Trace output to Console
  22. Accept self-signed TLS/SSL certificate in VB.NET
  23. How to make a Windows Forms .NET application display as tray icon?
  24. LinqToSql declare and instantiate DataContext best practice?
  25. Process.Start a file without Extension
  26. Assigning a value to ComboBox Items
  27. Are nested Try/Catch blocks a bad idea?
  28. Shadows vs Overloads in VB.NET
  29. Custom button captions in .NET messagebox?
  30. As of today, what is the right way to work with COM objects? [duplicate]

Leave a Comment