Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PROBLEM WITH OLE AND EXCEL5 (URGENT)
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
PROBLEM WITH OLE AND EXCEL5 (URGENT)
Miscellaneous
Thread ID:
00012877
Message ID:
00012877
Views:
82
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
Map
View

Click here to load this message in the networking platform