David,
I am using a copy to _cliptext in VFP and a .past in excel and that is a lot(!) faster.
Thanks
Peter
>Peter,
>
>Make sure Excel is not Visible it'll run quite a bit faster. And minimize the number of method calls you are making.
>
>Can you do something like create the 10 sheets as DBF files and then just make a couple of Excel calls to let it open each file instead of populating each cell individually.
>
>>I have program which exports a report to excel. I use office aoutomation to fill the rows/cells with data from queries.
>>The problem is it writes several thousand lines to 10 different worksheets in one .xls file.
>>
>>And it runs for hours! I means if I start in the aftrnoon it isn't done the next morning!
>>
>>I need to use a template sheet for the headers
>>
>>Is there a fast way to append a whole cursor/table to for example worksheet 3 starting at row 6?
>>
>>like :
>>
>>oExcel.Worksheet(3).InsertDBF(6,1)
>>
>>HELP!
>>
>>Peter
Peter Cortiel