error trapping

[EyeTalion]

I hate to bring up the issue of the Exit Sub Procedure...it seems to be a touchy topic in here...but here goes...

in a Try, Catch structure will the code always go to Finally? Even if there is an Exit Sub in the Catch portion?

My question is pertaining to closing a connection?

thanks

[Xmas79]

Try it

Public Sub DivideByZero()
        Dim x As Long
        Dim y As Long = 0
 
        Try
            x = 2 \ y
        Catch eg As Exception
            Exit Sub
        Finally
            MsgBox("Got Finally executed ))")
        End Try
End Function

Wrote it on the fly...

[EyeTalion]

if you dont have the exit sub in the catch portion...will the code still run through the rest of the procedure?

[Xmas79]

If you don't have the Exit Sub statement it will go...

[Pirate]

MSDN
An "enabled" error handler is one that is turned on by an On Error statement; an "active" error handler is an enabled handler that is in the process of handling an error. If an error occurs while an error handler is active (between the occurrence of the error and a Resume, Exit Sub, Exit Function, or Exit Property statement), the current procedure's error handler can't handle the error.

[Xmas79]

Pirate: What do you mean?

Public Sub DivideByZero()
        Dim x As Long
        Dim y As Long = 0
 
        Try
            x = 2 \ y
        Catch eg As Exception
            'Here errors can't be handled unless another try statement?
            ' x= 2 \ y    throws an error!!!
        Finally
            MsgBox("Got Finally executed ))")
        End Try
End Function

Sure is that what you mean...

[VBCrazyCoder]

If you cause an error in your catch block then it will be unhandled unless you have it in its own try block.

[Cander]

Finally ALWAYS will fire wether you get an error or not, and yes it will fire off before you 'Return'/Exit Sub! (Use Return )