Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement