>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.
>
>A tall order?
>
>Thanks for listening
>
>Terry

Terry,

For the first part:

ox = CREATEOBJECT('Excel.Application')
ob = ox.Workbooks.Open('YourWorkbook.xls')
os1 = ob.Worksheets(1)
os2 = ob.Worksheets(2)
os3 = ob.Worksheets(3)

Regards,