Hi, in my opinion, you have to initialise the Sqldb with valid
authentication, connection string/DSN etc.... and then try running the
statement.

"Arron" wrote:

Dear all,
I want to use Excel VBA program to execute SQL SERVER stored procedure.
But error occurs."Error sql statement ,except Insert update delete procedure"
How can I correct this ? thanks

code:
sqlstr = "exec stored_proc_name('Parameter')"
Sqldb.Execute sqlstr