>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 #
1302705and also
Re: Excel automation - formula Thread #
1238295 Message #
1238309
If it's not broken, fix it until it is.
My Blog