>I'm finding it necessary to export data to a series of Excel spreadsheets. Not a problem, EXCEPT how do I export to multiple PAGES? i.e., stuff meeting condition A goes to Page 1, condition B to page 2, etc... No help in my VFP documentation, at least not that I could find. I'd like to be able to handle this completely within the VFP code, rather than having to manipulate the data within Excel to break it out to its respective pages.
>
>Thanks.
VFP's COPY TO .. TYPE XLS will only get you so far. For anything more than the very most basic exports, you should be automating excel, and building the spreadsheet by scanning through your table. Check the solutions sample app for ideas on how to get started on this, and use the Excel Object browser in the VBA editor to get you past that.
It's going to take a little more work than COPY TO...
Erik Moore
Clientelligence