Hi all,

I'm putting together a front-end for an Access 97 database, using VB6 and CR4.

I want to export data to Excel 5 (as late as CR4 will let you). I have used that button on the bottom of the CR4 window in the past, just out of curiosity. Now I really do want to use it, and it's not responding.

If I open the report in the CR4 workspace, I can use the icon on the menu bar, and export the data to Excel or wherever. But from VB6, if I open the report to a window (crpReports.Destination = 0) the icon on the bottom of the window doesn't respond, and if I try to open to a file:

Code:
    crpReports.Destination = 2
    crpReports.PrintFileType = crptExcel50
    crpReports.PrintFileName = "c:/postnate.xls"
    crpReports.ReportFileName = "postnates.rpt"
    crpReports.PrintReport
likewise nada.

Because it works from the CR4 workspace, it makes me think there must be something with the CR4 object in the VB6 application. But I've tried working with the properties of that object, nothing seems to make any difference.

The 'print to a file' thing has worked with this project before, at least from the CR4 display window.

Any ideas gratefully accepted, Peter