>We have a rather complex report that the customer would like to see and manipulate via an Excel spreadsheet. Is there any way to redirect the output to a spreadsheet? We have worked some with reporting to ASCII, but the results were less than favorable.
>
>Thanks!
Daryl, you may find it simpler to send the data source for your report (a cursor, I hope) to and XLS file. Then you can open Excel with Ole Automation, format the data and let the customer have it.
If you need the specific commands to format the sheet the way you want, start a macro, do the formatting and read the results. Most of the commands can be copied directly into VFP.
Barbara