>I tried the command line below borrowed from "Ms Office Automation with VFP" but it wont work. Got OLE error message.
>Any help?
>
>oExcel.ActiveSheet.Range("K:22").Formula = "=SUM(K19;K16;K10;K7)"
>
What exactly is the error? Could it be that you need to use , instead of ; ?
See
Re: Formulas in Excel Thread #
1203274 Message #
1203319Also your range doesn't look right to me.
If it's not broken, fix it until it is.
My Blog