Could you please let me know why my code below isn't working?
Set cmd = New ADODB.Command
cmd.ActiveConnection = Cn
cmd.CommandText = "Exec TRP.M_Par_update_process"
'cmd.CommandTimeout = 1200 ' 20 minutes
cmd.CommandType = adCmdStoredProc
cmd.Execute , , adAsyncExecute
MsgBox ("Loaded & Processed!")
When a button in Excel is clicked, I want it to execute a store procedure name "TRP.M_Par_update_process" in the SQL Server without having to wait in Excel until the procedure is completely done.