>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
My download #
9991 is a class that does both text reports and Excel reports. Sample included. It helps ease the pain by doing some of the repetitive stuff - for example, you can define a group expression, and automatically print certain stuff in .GroupHeader() and .GroupFooter() methods.
Take a look at it, and ask back for any questions.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)