Call Stored Proc With Parameters From Excel

[NeedForExcel]

I missed out in the Title that its a SSMS Stored Procedure

Please Login or Register  to view this content.

This procedure runs perfectly when the Red line is commented and Green line is uncommented. But when I comment the Green line and Run the Red Line, it returns an error (Screenshot Attached) on the Blue Line.

Surprisingly, the Red Line executed perfectly fine on SSMS.

I tried changing adCmdText to adCmdStoredProc but does not seem to work.

Can anyone guide me what might be wrong?

[AB33]

I am not going to give you the full code, but you have left out a number of commands. You can google it.

Please Login or Register  to view this content.

[NeedForExcel]

Hi AB33,

Thank you for the reply.

Actually I had done something very similar before posting it to Excel Forum.

This is what my code looked like -

Please Login or Register  to view this content.

But the return_value seems to be the troublesome part.

I also tried changing adParamReturnValue to adParamOutput. I also tried placing ReturnValue as the 1st parameter in the code.

I get an error -

Run-time error '-2147217900 (80040e14)'

Procedure or function Customer_Data has too many arguments specified. (It is treating the return value as a Parameter) I am not very sure how to handle return value because of my limited knowledge of SQL.

[NeedForExcel]

Hi!

I have managed to resolve the problem.

The issue was at the the SQL Level. As soon I added the line "Set NOCOUNT ON" the Code started working.

Thank you for the help.



Rep Added