View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Rheaume Barb Rheaume is offline
external usenet poster
 
Posts: 2
Default run time error 2147217900

Hi,

I have a macro that runs a sql stored procedure and brings
back a record set.

I can run it once and get my results. If I kick off the
macro a 2nd time, I get the run time error "procedure or
function sp_x has too many arguments specified". If I
choose end, and try the macro for the 3rd time, it works
again. It's almost like I'm not disconnecting
something. It doesn't matter which stored procedure I'm
running (several similar), it's always the 2nd try after a
successful run. If I run sp_1, and my 2nd try is for
sp_3, I will get stopped for the same reason.

Does anyone have any ideas?

Thanks,

Barb