How to export data from a CrystalReport to an excelsheet by using CrystalReportExport

[elizab]

hi all,

I have a vb6.0 project that is containing only modules(dll). Not using any VB forms. so i am not able to get crystal report control. I am displaying the report in an asp page. Database tables are connected to my report from which data will be coming.I want to extract data from a report file to an excel sheet and open it .
ie I should get only the excel sheet as the output.
Can i do it from the module without opening the reportfile using like...CrystalReportExport. How can I use this?Is there any other way?

Can anyone help me..

thanks & regards
elizab

[Madhi]

Try this

CrRpt.ExportOptions.FormatType = crEFTExcel97
CrRpt.ExportOptions.DestinationType = crEDTDiskFile
CrRpt.ExportOptions.DiskFileName = "D:\export.XLS"
CrRpt.Export (False)