Crytal report -> export to excel

Can anyone tell me how can i export crystal report to an excel file in visual basic 6?

Moved from the CodeBank

Hi.
In vb.net its very simple.

Code:

---

crReportDocument.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile
crReportDocument.ExportOptions.ExportFormatType = ExportFormatType.Excel
crReportDocument.Export()

---

EXPORTING DLLs


Distribute these DLLs if your application has exporting functionality. Only those DLLs distributed will be valid options for exporting. For example, if only U2ddisk.dll and U2fcr.dll are distributed, then you can only export a report to a file disk in a Crystal Report format.


Refer to 'Runtime.hlp' and look under 'Exporting' for more information.