Calling SQL Stored Proc Using ADO (Run Time Error 3704)

Hi,

I am calling 2 Identical Stored Procs Using ADO.

Both the Stored Procs are absolutely identical with the same Parameters.

One is running just fine, but the other returns this error message.

Capture.GIF

The Code returns error on this line "Data.Range("I2").CopyFromRecordset RecordSet"

Code -

Please Login or Register  to view this content.

Any Ideas?

Problem Solved

Instead of

StoredProcName = "AvgTime dealbooking"

I Used

StoredProcName = "[AvgTime dealbooking]"