I've recently done this for a project I was working on, all you need is a reference adding to ActiveX Data Objects

Public Function ExecuteSP(strStoredProcedure As String) As Long

Dim objCmd As...