Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Totaling financial columns
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01514018
Message ID:
01514023
Views:
48
>If you want to total financial columns in Office Automation for EXCEL (in FoxPro) and you have 12 months of data from left to right, how would you do this? I don't want to use FoxPro to total the columns, but EXCEL.

You will need to use a formula in Excel.
Check example in Re: Excel insert a sum function in code Thread #1302702 Message #1302705
and also Re: Excel automation - formula Thread #1238295 Message #1238309
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform