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