Hi Hilmar,

Thanks for responding...I will keep your note handy for when I get into working with Excel - especially if I need pivot table support.

Albert

>I do a lot with pivot cache/table and pivot field automation. If you find yourself involved in this somewhat arcane but really really powerul world (semi-OLAP) then I could send the classes. Documentation does not exist but if you want to be able to bind a foxpro table to a pivot cache it might still be handy.
>
>What's cool about Pivot Table reports is that your customers can format the excel and do the design -- you just refresh the data.
>
>>Hi all,
>>
>>I could go looking around but just wondered if anyone has released classes to automate Word and Excel? I have the book "Microsoft Office Automation with Visual Foxpro" and its all good stuff - but I think I could sell a client on doing some automation stuff if I did not have to spend time first writing a generic Word and Excel class to do stuff like opening each of these, opening/closing documents and all that housekeeping kind of stuff.
>>
>>Anything out there either free or commercial?
>>
>>Albert