It is in VFP tables, then I am putting it into the speadsheet. Part of the reason for doing it this way is that the client I provide these for does not have VFP and wants the info in the spreadsheet.


>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.