Then you probably are talking about something similar to this:
ObjExcel= CREATEOBJECT("Excel.Application")
with ObjExcel
.Workbooks.open(yourfile)
lcRange="A2"
.Range(lcRange).Select
.Rows(TRANSFORM(.ActiveCell.row)+":"+TRANSFORM(.ActiveSheet.UsedRange.Rows.Count)).Delete
use your table
_VFP.Datatoclip(,,3)
.ActiveSheet.Paste()
.........
>hi,
>thank you for reply.
>if i have one sheet and the same fields at vfp table and excel sheet,
>juse i want to keep the all titel as it is at myexcel sheet when i make a copy form vfp table,
>if you can compleat the copy statment[copy to ... XLS] or just somthing
>like (copy file t1.dbf to c:\exel123\gg.xls).
>thanks.