SQL Stored Procedure From Excel

Hi,

I have a stored Procedure that updates only 1 row (No changes in the count of rows).

I am using the below code to execute the Stored Procedure.

Sub ExecuteStoredProcUpdate_Yield()

    Dim SQLConn As ADODB.Connection
    Dim SQLCommand As ADODB.Command
    Dim SourceQuery As String

    Set SQLConn = New ADODB.Connection
    Set SQLCommand = New ADODB.Command
    
    SQLConn.ConnectionString = ConnString
    
    SourceQuery = "EXECUTE DB_Common..Update_Yield"
         
    On Error GoTo CloseConnection
    
    SQLConn.Open
    
    With SQLCommand
        .ActiveConnection = SQLConn
        .CommandType = adCmdStoredProc
        .CommandText = SourceQuery
    End With
                
    On Error GoTo 0
    SQLConn.Close
    
    Exit Sub
    
CloseConnection:
    MsgBox "SQL Stored Procedure Did Not Execute Sucessfully!", vbOKOnly, "SQL Error"
    SQLConn.Close

End Sub

Is there a way I come to know If the Stored Proc Executed properly?

Is there a way of knowing if it is running as desired at all?