How do I call a SQL Server store procedure to run from Excel without having Excel hanging with hourglass? For example if my SQL store procedure takes 10 mins to run, then the Excel is hanging in there for 10 mins at the "cmd.Excecute" line. Is there a way to run the sp in the background and let Excel continue to the next line?
If Me.M_Sat_Load_and_process Then
Set cmd = New ADODB.Command
cmd.ActiveConnection = Cn
cmd.CommandText = "Exec TRP.M_Sat_update_process"
cmd.CommandTimeout = 1200 ' 20 minutes
MsgBox ("Loaded & Processed!")
MsgBox ("Only loaded, please process!")