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