VB 6.0 app using Crystal ocx
Posted on 2003-04-01
I have a VB 6.0 application using the crystal ocx. The report was created in Crystal 8.0. Here are my report properties:
CrystalReport1.Destination = crptMapi
CrystalReport1.EMailSubject = "New Hire - Rehire Report"
CrystalReport1.EMailToList = "hayes heather"
CrystalReport1.PrintFileType = crptExcel50
CrystalReport1.Action = Enabled
When a field on the report is 0 it is displayed as "<Default Format>" in the excel spreadsheet. I have tried just exporting the report with crystal to excel and it works fine, but I get different versions of excel to export. I believe I am having problems because I am exporting to Excel 5.0. I have Excel 2000 loaded on my client machine. Is there a way to update the ocx to have the option to export to Excel 7.0?