>Hi martina,
>
>oExcel.Cells(rows,Cols+5).Formula = "=SUM(F8:F&rows)" result is #NAME?
>
>any suggestion on how i can find references on this?
>
>thanks

The problem here is almost certainly the macro. Try building the string in pieces:

oExcel.Cells(rows,Cols+5).Formula = "=SUM(F8:F" + TRANSFORM(m.rows) + ")"

In general, search for Excel VBA for resources as to what the appropriate Excel objects and PEMs are. You'll find an introduction to Office Automation on my site at http://www.tomorrowssolutionsllc.com/Conference%20Sessions/Getting%20Started%20with%20Office%20Automation.pdf. You might also find the book Della Martin and I wrote about the subject useful: http://hentzenwerke.com/catalog/autofox.htm

Tamar