Combine the worksheets into one spread sheet. Add an empty worksheet. Set up a column in the new worksheet that references the cell(s) from your source worksheets.
Or, you could (through a VFP excel object) read the cell values from your source sheets and write them to a "new" sheet.
Or, you could import the spead sheets into VFP cursors, create a a new VFP cursor, programatically update the new cursor with the source cursors and then copy the "new" cursor to a worksheet.
>I have three xls documents that I want to combine programticly to 1 document by coping the row from each and pasting them into one new document. Does anyone know the easiest way to do this?
>Each document has roughly 5,000 rows and each has 10 columns
Imagination is more important than knowledge