General information
Title:
PROBLEM WITH OLE AND EXCEL5 (URGENT)
Hello....I'm come back with a new problem !!!!! (and excuse my english again.....)
I try to update an Excel worksheet....from Visual foxpro 3.0....with data from a DBF table...
I can't use the command COPY to...TYPE XLS, because my Worksheet exist and I want to copy data
in different place of my worksheet..and on different sheet
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only