Thanks for the quick help, but...
I used this code (from the book):

oExcel.ActiveSheet.Range("C22").Formula = "=SUM(C5:C20)"

I tried this:

oExcel.ActiveSheet.Cell(11,22).Formula = "=SUM(K19;K16;K10;K7)"

But I got this error message:
"OLE error code:0x80020006:Unknown name"(in Hungarian)

I also tried this:

oExcel.ActiveSheet.Range("K22").Formula = "=SUM(K19;K16;K10;K7)"

And I got this error message:
"OLE error code:0x800a03ec:Unknown COM status code"

It may have sg. to do with the Hungarian version of Ms Excel?
I gonna check Naomi's links.

Thanks again,
Tamas


>>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)"
>>

>
>Unfortunately I didn't have Excel installed on my home computer, so I can't test but I thik you need something like:
>

>oExcel.ActiveSheet.Cell(11,22).Formula = "=SUM(K19;K16;K10;K7)"
>

>But again, this is didn't tested.