Thanks Hilmar. I've tried these things and they work just great.
>Some optinos for fast access are:
>
Copy & Paste.
>COPY TO ... TYPE XLS; then use Automation for some finer control.
>Omit zero or blank values if it makes sense to do so. A conditional in VFP is much faster than a useless communication between VFP and Excel.
>Process multiple cells at once, like this:
>
>>.Range(.Cell(1,1), .Cell(5,5)).Font.Bold = -1
>
>
>
>>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?