Where do you keep the data? In VFP tables or in the spreadsheet ?
>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.
Birger G. Thoresen
Pek og Klikk