Hi Fracois,

Just a thought....

I wonder, if you concatenated your array of values (something) like this:

m.RowString=''
FOR i=1 to alen(myFoxArray)
   m.RowString=m.RowString+myFoxArray[i]+CHR(13)
ENDFOR

If you could then select a range of cells in Excel and then do a paste or pastespecial.

If something like the above worked, it would have to be faster than plugging in each individual cell value.

Hugh

>Hi all vfp8 beta-testers (lucky you)
>
>We use vfp-to-excel integration a lot...
>Everything is ok except that we can run:
>
>1) oExcel.sheets(1).cells(1,1).value = myfoxvalue
>but found no way to run:
>2) oExcel.sheets(1).range("A2:A100") = myfoxarray
>
>Is it possible to dump the new arrrays from vfp8 into
>ms excel (possible in delphi and vb).
>
>Solution 1) is unpratictable for significant datasets.
>
>Regards to all