CopyFromRecordset

Hi All,

Im using the following code to get data into a recordset (successfully) - But because i often recieve more than 1 record, the recordset fills in each row beneath the cell which is referenced.

Because the program is looking at a reference cell in each row, the recordset, when more the 1 is returned from the previous call now gets overwritten.

I would like to have each record go across the columns instead, but i can't figure out what to change in this code to make it work?

Eg: I'm trying to retrieve 3 fields to put into Columns C, D & E. If I return 2 records, i want the 2nd record to go into Columns F, G & H.

Hope i've explained this OK?? Excel 2003.

Can anybody offer up a solution?

Cheers All,

Bam.

Please Login or Register  to view this content.

One way might be to push the recordset into a Variant Array and iterate accordingly.
With each iteration the "paste cell" is set to be the first empty column from the right for the row as determined by the passed range.

Please Login or Register  to view this content.