Dear experts,

I want to export Crystal Report to excel file with multiple worksheet. I have 5 crystal report, each report will be exported to a worksheet in the same excel file.

Right now, I'm using ExportToDisk method but all it does is exporting the crystal report to one excel file in one sheet. Then I try to export the next crystal report to that same excel file. Instead of appending the already existing file, it overrides the file.

I'm using VB and Crystal Report in VS 2005.

Thanks in advance.