sending Cresyal Report to excel format

I'm using Crystal Reports 8 to develop reports for a VB 6 app .and i want to send the report to excel format from the
application .How Can i di it ?

Assuming a report object names rptMyReport:

Code:

---

rptMyReport.ExportOptions.DestinationDLLName="u2fxls.dll"
rptMyReport.ExportOptions.DestinationType=crEDTDiskFile
rptMyReport.ExportOptions.DiskFileName="MyExcelFile.xls"
rptMyReport.ExportOptions.FormatType=crEFTExcel50
rptMyReport.Export

---

Quote:

---

Originally posted by monte96
Assuming a report object names rptMyReport:

Code:

---

rptMyReport.ExportOptions.DestinationDLLName="u2fxls.dll"
rptMyReport.ExportOptions.DestinationType=crEDTDiskFile
rptMyReport.ExportOptions.DiskFileName="MyExcelFile.xls"
rptMyReport.ExportOptions.FormatType=crEFTExcel50
rptMyReport.Export

---

---

Thank you for your help
Then how can i export it to excel 7?

It will open in Excel 7..

Crystal hasn't changed it's export dlls to support Excel 7 directly since the basic format it needs to meet hasn't changed.