View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Recordset or Object is closed HELP PLEASE!

oelfaa wrote ...
hi
i've read your solutions but they don't help me. this is the first time i'm doing VBA. i get the same error but i do use a stored procedure. it gives me that '3704 operation not allowed when the object is closed' on this statement :

Sheet1.Range("A4").CopyFromRecordset rsBDA


Post the rest of your code.

Jamie.

--