>Hi guys
>
>I need to do 2 things:
>
>1) from my current cursor I need to produce 3 worksheets in the same book, each being more of a summary of the previous.
>i.e. I have a cursor with all the data, cut down to sub-totals and totals, and cut down to just totals (and a grand total for each, of course). I know how to reduce the cursor for each sheet, but how to include each one in the same book.
>
2) VFP currently does the above totals/sub-totals but my users would prefer the SUM() function, as they may need to insewrt extra rows in the s/s/ afterwards. I imagine this is a bit tricky.

Actually, it's not too tricky, once you discover the property "Formula" of a cell object.

LOCAL nRowStart,nRowEnd
*m.nColumnStart && This will have to be translated into "A,B,C..." 
*m.nColumnEnd && This will have to be translated into "A,B,C..." 
*For simplicity, I'm not using the columns.  But you get the idea.

m.nRowStart = 1 && This may be dictated by your report layout
m.nRowEnd = 100 && This may be dictated by your report layout
exelApp.WorkSheets(1).Cells(1,2).Value = "Total:"
exelApp.WorkSheets(1).Cells(1,3).Formula = ;
    "=SUM(A" + transform(m.nRowStart) + ":A" ;
   + transform(m.nRowEnd) && This yields SUM(A1:A100)

HTH