>But the problem is that when I copy more then 1500 data, the program fall down!!!
>I work on a pentium with 16Mo of RAM...
>Do you know why my program fall down ?????
>Have you got a solution to update a worksheet???????
>Please help me...It's very important...Thanks a lot...
>
>oleApp=CREATEOBJECT("Excel.Application")
>oleApp.WorkBooks.Open("c:\livdemo\winxls1.xls")
>FOR t= 2 to 20
> oleApp.WorkSheets(t-1).Activate
> FOR x=1 to 7 oleApp.Cells(x,1).Value=ta[x,1]
> ENDFOR
>ENDFOR
>oleApp.ActiveWorkBook.SaveAs("test")
>oleApp.Quit
>release oleApp
If you are opening 18 worksheets, that surely uses a lot of memory?
I agree, it shouldn't crash. My only experience was with DDE and not OLE (I was using FoxPro 2.6) and had mo similar problems there.
Are you using FoxPro 3.0b or 3.0? Windows 95 or 3.1?
FoxPro 3.0b and Win'95 or NT are less likely to suffer memory problems.