>>Hi all,
>>
>>Is there a way to copy a report to MS-Excel, as previewed or printed???
>
>The replies to your query may not understand what you want. The weakness of the vfp report is that it is for the moment only. I use Excel reporting when I want a permanent record of something from my database. I'd suggest two ways to get nicely laid out reports in Excel.
>
>1. Cut down the reporting code in vfp by SQLing to a cursor, then counting or summarising in some way. Keep it simple. Now export to an XL5 worksheet and switch to Excel. In Excel turn on Record Macro and perform the steps you require for laying out the report. Edit the VBA code and fine tune the page setup parts and, ideally add a special purpose autoloading toolbar, you have an Excel report formatter you can re-use over and over. In tests about two years ago I found that running Excel fro vfp was (a) extremely slow and (b) a nuisance for customisation because you have too much code committed inside the vfp application. The speed concern may not be so important today, but the ease of customisation problem won't have gone away.
>
>2. Second method is to download Microsoft's July 31 release of MDAC (Data Access Components) and query your vfp database from within Excel. Then do your Excel layout and stats tricks as before. This has the excellent advantage that you can hand over a finished vfp application but _and_ a querying 'starter kit' consisting of an Excel workbook which a user can fiddle about with when you're not there.
>
>HTH
>John Burton

VFP report can be stored permanently too, not just for a moment. Any excel data can be hooked from VFP and moved there quickly.