>>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