Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need a big help please!
Message
From
06/02/2000 12:52:03
Fernando España
Alta Tecnologia En Informatica
Guatemala, Guatemala
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Need a big help please!
Miscellaneous
Thread ID:
00328050
Message ID:
00328050
Views:
59
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
Next
Reply
Map
View

Click here to load this message in the networking platform