>>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,
Thanks Jim
I can see that that references 3 worksheets within a book, but how to export my respective cursors into trhe 3 sheets?
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.