Randall,

Jay gave you a solution which prepares your data the way you want. The alternative is to put the data into Excel the way you are doing and then use Automation to cut the data from the right-side columns and paste it where you want it.

To see how to do this, open a workbook with typical data, start a macro, do what you want, stop recording the macro, then open the VBA editor and look at the macro. Use the code there as the basis for your VFP code.


>I have several Tables with data that I copy over to an excel spreadsheet. I never have to worry about the number of records exceeding the alloted number of rows. The spreadsheet ends up having cloumns "A" through "AI." I would rather have the colums appear under each other. I other words:
>
>ColumnA columnB columnC columD columnE columnF in table
>
>in spreadsheet
>
>ColumnA columnB columnC
>columD columnE columnF
>
>all fo the colums have different headers or names. Is this possible in VFP?