ADO and Multiple Worksheets

[WOTRAC]

Can anyone give me a kick start on this one, as I need a bit of help.
I have a recordset which may contain anywhere from 3 to 6 records. I want each record to be placed in a seperate worksheet in the same workbook.

I know how to get the data from the database, but exactly how do I loop through the worksheets, at the same time as looping through the recordset.

 

[PHV]

And what have you so far ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

Hi,

You could use the Sheet Index

i = 1
Do While ...
  ....
  
  Sheets(i).MyRange([i]n[/i]) = rst!Field[i]n[/i]
  i = i + 1
Loop

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884