OK Team,

I need to retrieve five queries from (Stored Procedures) SQLserver and paste them onto five different worksheets. I thought I'd try to be clever and get all the data in one hit using the multiple recordset feature of ADO, and then loop through them, pasting each one to a new sheet using CopyFromRecordset.

The problem is that while the CopyFromRecordset for first recordset works fine, all subsequent sets complain about being closed. Is CopyFromRecordset meant to close recordsets? I could understand it setting EOF to true, but that should only affect the current set anyway.

Cheers,

Chris

There are two secrets to success in this world:
1. Never tell everything you know

__________________
There are two secrets to success in this world:
1. Never tell everything you know

Hi Cris,

CopyFromRecordset dos't mean close recordsets.Make shore that you are itrating properly using recordset.NextRecordset or subsequent recordset are not blank

Just a thought: before Copying from the next recordset it may be usefull to execute the recordset.Movefirst, as the method begins with the current record.
It may also be helpfull to close the first recordset and set it to Nothing, freeing up some memory.

Mihai

can you paste some code?