how to Excel run SQL Server Stored Procedure

[yippee2]

I am trying to run SQL Server Store Procedure from Excel. I have the following code which ran with no error in Excel but did not seem to do anything in SQL Server. What could be wrong.
Also how can I check the the connection is setup correctly and working? Thanks

Sub Bld_Eol_Bom_Data()

Dim sqlStatement As String
sqlStatement = "EXECUTE dbo.bld_eol_bom ;"
Debug.Print sqlStatement
With ActiveWorkbook.Connections("hhi-t-sql05-eSearch").OLEDBConnection.CommandText = sqlStatement
End With
ActiveWorkbook.Connections("hhi-t-sql05-eSearch").Refresh​

End Sub