sending Cresyal Report to excel format

**beni** · Nov 8th, 2000, 08:18 AM

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 ?

**monte96** · Nov 8th, 2000, 10:25 AM

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

**beni** · Nov 9th, 2000, 05:23 AM

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?

**monte96** · Nov 9th, 2000, 11:09 AM

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.

Thread: sending Cresyal Report to excel format

Thread Tools

Display

Posting Permissions