Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need a big help please!
Message
 
 
To
06/02/2000 12:52:03
Fernando España
Alta Tecnologia En Informatica
Guatemala, Guatemala
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00328050
Message ID:
00328062
Views:
22
Fernando,

Your English is pretty good. The problem is the cells in Excel aren't by default addressed by the name (Sueldo and Cantidad) unless you give the cells a range name.

appl.cells(2,3).value="=a2*b2" && should work better

>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
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform