I´m using vfp with excel for calculate a formula
a´m using the following sintax to send my formulas
all works fine,but my formulas are not evaluated!
what I´m doing bad?
appl=getobject("excel.sheet") &&this is OK
appl.AcceptLabelsInFormulas="True" &&this is OK
Appl.CalculationMode=3 &&This is OK
appl.cells(1,1).value="Sueldo" &&This is OK
appl.cells(1,2).value="Cantidad" &&This is OK
appl.cells(1,3).value="Total" &&This is OK
appl.cells(2,1).value=500 &&This is OK
appl.cells(2,2).value=10 &&This is OK
appl.cells(2,3).value="=Sueldo*Cantidad" &&This is Not OK
&&Excell not take this like
&& a Formula What is Wrong?
appl.calulate &&this is ok
Sorry with my english..
Thanks.
Fernando España
SQL Server Specialist