Does anyone have any tips for speeding up the creation of excel files using
createobj('excel.application')
and then populating cells with
oApp.workbooks(1).sheets(1).cell(x, y) = {somevalue}
Doing it this way gives me the control I need over multiple sheets but is MUCH slower than COPY TO {ddd} TYPE XLS.
For example, are their some properties of the excel object I can set to speed things up?