>>>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
>>
>>
>>Hi Terry,
>>
>>Have look at rep2excel tool here in downloads. ( download#14800 )
>>
>>It is class object with wrappers for most of common excel writing tasks.
>>You can write entire tables,arrays,delimited strings, set formulas, fonts
>>print area, insert pictures etc. at any position in excel file using simple wrapper calls. (class methods)
>>Also, it has embeded simple reporting engine (grouping,bands etc)
>>
>>Will save you of hundreds of lines of complicated/repetive automation code.
>
>Hello Srdjan
>
>Thank you very much for that. I've been looking at it with great interest but haven't got much time for learning how to use it thoroughly. I'm not sure it will save me much for the current task, given Jim's sample but I'll see how I get on.

There are few examples there that can get u started.
But in order to avoid problems, pls create C:\windows\desktop folder
(default output destination) or find/amend respective property that keeps output destination.


Maybe this task of yours is simpler then I tought, but this will save you lot of coding on future complex exports.