Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace into excel
Message
 
To
05/10/2004 15:46:21
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00948894
Message ID:
00948919
Views:
16
Then you probably are talking about something similar to this:
ObjExcel= CREATEOBJECT("Excel.Application")
with ObjExcel
     .Workbooks.open(yourfile)
      lcRange="A2"  &&starting cell
      .Range(lcRange).Select
     .Rows(TRANSFORM(.ActiveCell.row)+":"+TRANSFORM(.ActiveSheet.UsedRange.Rows.Count)).Delete  &&remove all data

     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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform