Release Object

Releases a COM object from memory and forces garbage collection to clean up unmanaged resources.

This function safely releases COM objects such as Excel or Word interop instances using Marshal.ReleaseComObject . After releasing the object, it is set to Nothing and garbage collection is triggered to ensure cleanup of any remaining resources.

    Public Sub ReleaseObject(ByRef obj As Object)
        Try
            If obj IsNot Nothing Then
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            End If
        Catch ex As Exception
        Finally
            obj = Nothing
            GC.Collect()
            GC.WaitForPendingFinalizers()
        End Try
    End Sub

    Public Sub ReleaseObject(ByRef obj As Object)
        Try
            If obj IsNot Nothing Then
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            End If
        Catch ex As Exception
        Finally
            obj = Nothing
            GC.Collect()
            GC.WaitForPendingFinalizers()
        End Try
    End Sub

Posted by ipercube