Rene,
Is the cursor small enough that you use OLE automation of Excel to populate the spreadsheet? It would take longer to run but you'll get the right result.
I think you could also automate Excel to open the DBF and SaveAs XLS.
>I'm doing a "copy to myfile type xls" command from VFP 6. There is a date field in my source file (a cursor in this case). In Excel (Excel 97) the resulting field is not formatted as a date field, but as a text field. Changing it in Excel (using the Format field command) works fine, but sorting on the field sorts it 01/02/67, 01/03/52, 01/04/87, etc.
>
>Any idea if there is a workaround for this? I've tried changing the date within VFP to a different format (such as SET DATE ANSI, result = 1967.02.01), but this makes no difference.