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