Actually, I am updating existing files. These are used to store year-to-date values and print graphs. Each month I am adding the values for the month just completed.



>Did you try the export wizard ?
>EXPORT TO FileName TYPE XL5
> [FIELDS FieldList]
> [Scope]
> [FOR lExpression1]
> [WHILE lExpression2]
> [NOOPTIMIZE]
> [AS nCodePage]
>Creates an excel spreadsheet FAST.
>
>>I have been working on updating an Excel spreadsheet with data from VFP 6. I can do all of the basic processes, but the way I am updating is very slow. I am currently using oleapp.range("A1").value=somevalue then oleapp.range("A2").value=anothervalue and so on. Some of these processes involve a large amount of data. Is there a way to select a range of cells and update them all from an array or other source that would improve the performance?
>>
>>Thanks in advance for any suggestions.