Peter,
So is it solved for you (expect under 10 mins on an 650Mhz with 192Mb RAM)? If not would you share code portion that's exporting to Excel.
Tip: If possible use multiple workbooks not worksheets and use direct fox2x dbf (or CSV, delimited) opening in Excel.
Cetin
>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