>I ned to run lots of output from 5.0 into excel sheets but the copy type xls command produces a very ruddy unformatted sheet which has to be worked on...(col headings, sizing, numerical formats etc).
>
>Is there a tool to do this? Is it a task for some VBA?
>
>TIA
>Chris
You can pretty easily automate Excel to do this. You could even create a routine to do it automatically for any cursor. Use AFIELDS to get row 1 headings, then SCAN through oyur table and plug the values into the sheet. Record a macro in Excel and look at the VBA code to get an idea of how to start. There are also a sample or two inthe solutions app that comes with VFP.
Erik Moore
Clientelligence