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
James Beerbower
James Beerbower Enterprises
Frankfurt, Deutschland