Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ole trouble
Message
De
16/10/1997 16:52:57
 
 
À
16/10/1997 16:47:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00054990
Message ID:
00055011
Vues:
33
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform