What I ended up doing is using the _cliptext. I can string multiple cells using chr(13) for next row or chr(9) for next column and then
activesheet.paste to paste the clip text.
Thanks to everyone for their ideas.
>Hi again
>
>You might try _cliptext = tablefield in VFP then switch to Excel and paste.
>Should work if you have very few fields to update.
>OR
>Install VFP ODBC-drivers on the client-site and insert a link in the spreadsheet.
>
>>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.
Mark Johns