One thing for sure, you won't be able to get more then 65000 rows in a single worksheet but you can have more then 1 worksheet in a workbook!

How do you copy your data to Excel WorkSheet ?


>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.