If you do some searching here you will find a good example of how to do it. I just don't have the time right now to look it up, but basically you should:

1) query excel to determine max amount of rows in a sheet
2) Determine how many sheets you will require, and create more if necessary
3) In a loop in your program copy rows to Excel until the max is reached.
4) Skip to next sheet and repeat process.

>How to have 100000+ rows in excel using VB6 code.
>considering limitaions.
>
>1. Crystal can export only 16000 rows!
>2. Excel can hold only 65000 rows in one sheet.
>
>TIA
>Regards,
>Diptesh.