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.
Birger G. Thoresen
Pek og Klikk