>Ok,
>
>The problem is getting poudy big. I tried to populate the sheet one by one. I still didn't apply the format. The problem is that I have about 10 fields and more then 2000 rows. It's slow!!!!
>
>i use the cell propery of oexcel to populate it. I minimize the Excel windows and I win some performance point but it's still slow. very slow. I uses a pIII at 733 and 512 ram. Woudl that be a problem?
Automation time should be approximately proportional to the number of times you need to access Excel properties and methods from VFP - the major bottleneck seems to be the communication between VFP and Excel.
Depending on your particular situation, you might:
Copy to a dBASE file (TYPE FOXPLUS), or an Excel file, and then use a single Automation command to insert that into Excel.
Create a string, delimited with TAB and ENTER, in VFP, copy this to Clipboard, and then use a single Automation command in Excel, to paste it.
If you need to copy individual cells, you can still try to reduce the number of cells inserted individually:
If a numeric value is zero, omit it (don't assign it in Excel).
Instead of creating identical formulas one by one, use Copy and Paste within Excel.
HTH,
Hilmar.
>
>Thanks,
>ionut
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)