>This is the coolest technique since sliced bread.
>
>I have been creating very useful reports of accounting data as Excel sheets that use the Excel autofilter feature to present and total ad-hoc filtered views of data. Importing the accouning data and creating the spreadsheets is done directly from VFP in a straightforward, totally automatic and relatively fast way. When viewing the ad-hoc filtered views Excel runs super fast as usual. Seeing different cuts of the data one right after the other lets you get a good feel for the data.
>
>For the next step, I want to add the capability to drill-down into the data. The records are going to be there, just not visible until the user requests to see them. I think the Excel outline of rows feature will be the right tool, with calculated subtotals of hidden rows and then grand totals tha only sum detail data and not the intermediate subtotals. Cool.
>
>Suggestions are welcome.
>
>Alex

Hola Alejandro,

I apreciate very much your efforts in creating Excel solutions.
In fact, I've started using your "ExcelListener" recently - That's a very nice job !
Do you have a more recent version than the one published in the UT downloads ?

I'm using it in a custom toolbar that is used during report preview, it allows setting many options during the preview, specially saving the current report as PDF, RTF and XLS (using your listener).

Maybe you'd like to have a brief look at it?
Below is a link to my blog where I posted some info about that project, download links, pics, etc.
http://weblogs.foxite.com/vfpimaging/archive/2010/02/28/10127.aspx

This project is totally open source and freeware.