Creating More Worksheets in a Single Workbook.

Question

Hi

I have a Dataset that generates 6 reports simultaneously. Instead of displaying in the Crystal Report, I just wanted to save the  reports back to an excel file. How to do that? Please help me. Also in that process, there should be only one workbook, for eg. Book1.xls. It should contain all the 6 reports in seperate worksheets. Do anybody have an idea how to do it? I would appreciate if you give some sample code also. Thanks in advance.

Regards
Raja Raman S.
Bangalore.