How to export crystal report in excel with data only

Hi,

I am now using this code to export report to excel format

Code:

---

    Report.ExportOptions.ExcelExportAllPages = True
    Report.ExportOptions.DestinationType = crEDTDiskFile
    Report.ExportOptions.FormatType = crEFTExcel97
    Report.ExportOptions.DiskFileName = "D:\CommBackup\" & rs.Fields!MemberCode & "-" & Right(Year(DT1.Value), 2) & Format(Month(DT1.Value), "00") & ".xls"
    Report.Export (False)

---

But how to export to excel with data only ?

If you're saving an XLS file, it won't be text.

If you want to export data only I would consider using a query and save the data from the resulting recordset to a csv file.

Can't help with Crystal as I scrapped that software years ago in favor of a more VB friendly report tool.