I am running a SQL Stored Procedure from my VBA syntax, and all of my update/insert statements work as they should and if I run a select statement directly from sql server, I get the result set that I am expecting. However, my VBA returns an error of
Operation is not allowed when the object is closed

The last line of my Stored Procedure is
Please Login or Register  to view this content.
So the stored procedure is set to return results and the object should be open as I open it in my vba here
Please Login or Register  to view this content.
How can I return the data from my select statement at the end of my stored procedure back to Excel?