Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ole trouble
Message
From
16/10/1997 16:52:57
 
 
To
16/10/1997 16:47:03
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00054990
Message ID:
00055011
Views:
28
>>This is Excel workbook. You have to manipulate it from VFP to load file there. If you look at sample and in Excel VBA Help too, you fill find out what excel related stuff means.
>
>excuse me but i dont understand it...
>also i have a code like that
>
>sele finalx
>copy to array matcursor
>xl = CREA("EXCEL.sheet")
>xl.Application.Visible=.T.
>
>all = reccount("finalx")
>for i = 3 to todo
> xl.Cells(i,2).Value = matcursor(i,1)
> xl.Cells(i,3).Value = matcursor(i,2)
> xl.Cells(i,4).Value = matcursor(i,3)
> xl.Cells(i,5).Value = matcursor(i,4)
> xl.Cells(i,6).Value = matcursor(i,5)
> xl.Cells(i,7).Value = matcursor(i,6)
> xl.Cells(i,8).Value = matcursor(i,7)
>endfor
>
>when i run it the excel open an i can seer the records in the worsheet , but when it ends... the excell worsheet its cole
>i dont know if its a truoble of excell or visual... i never use something like
>
>xl.release or xl.quit
>
>are in this code something wrong?
>
Probably, this code is Ok. I prefer to load file, because it's much faster then using Cells method. I can guarantee that my code is working Ok, and I can guarantee nothing about your code. You know any OLE code should be tested on-site. If it works, then it's good.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform