Excel VBA Macro to Execute a Stored Procedure
September 20th, 2009 by Paul Kroon
The other day I came across a problem of running an MS SQL 2005 stored procedure in an Excel VBA macro. I had set this up before with another stored proc, which worked just fine. Copying this code (and later trying several other ways of doing it) always ended up with a closed recordset being […]