Ohh sorry Vinod.
1) The codes are for Off97. Things changed a little bit and why VFP5 samples were bombing on Off97 (and the reverse this bombs on Off95).
2) Then take relatively easy way and create an excel template. Use the template for a new sheet then using Application.datatoclip (was in code) paste to "pages". Template would typically contain totals formula beforehand. Or you could paste, insert formula below then paste again till EOF.
3) Pivot tables are for data summary true. But they not only contain summary. A sheet holds raw data, pivot holds its summary in virtually any way. You could see one running just CreateTestCursor part then calling VFP pivot wizard.
4) Code gave OLE error as expected ? :) It's again for Off97.
Cetin

>I’m very thankful to you for taking out your time and replying me for my problem..
>
>I’ve tried sample code (1st one) & went through your whole reply and I’ve many questions for the same…
>
>1. Sample code is giving Ole Error at
>
>lcHPB = .HPageBreaks(1).Location.Address(.f.,.f.,xlR1C1)
>
>Pls note that I’m using Off 95.. Is this code designed for 97 ?? Pls advs…
>
>2. For sample 1, u’ve written "its a nightmare to do it that way… & VFP report writer is more effective", Pls note that there are few reports in my current project which users wants to transfer in Excel… VFP reports are giving page wise totals, so same thing is req. in Excel… Pls advs. Ur comments…
>
>
>3. I’m not that much familiar with Pivot table (never used it before), As far as I know, its used for displaying Summary Data (Pls correct me if I’m wrong). As long as it is solving my problem, I don’t mind using it… But still it was not clear to me How it can be used in this situation ??
>
>4. I’ve haven’t tested the Pivot table code.. Looks like u’ve done extensive programming in this field.. (Speaking frankly, half of the code went abv my head).. I’ll try that code and advs. The results…
>
>
>Eagerly awaiting for your reply..
>
>Thnks n Rgds,
>Vinod
>
>
>