Della is being modest listing her book as solution #4. It really should be your first resource. It is amongst the best written computer books I have ever read. I was doing hard core automation in minutes (well, maybe an hour or two) from reading their book and going through the examples.

Thanks to their book, I do things which are frequently easier through automation than through Excel's manual interface, and which make clients' jaws drop. Graphing is the best example of that.

I've never met Della or Tamar (I hope to one day) - I'm just talking from personal experience. It's an awesome book. I read it cover to cover.


>Renior,
>
>Looks like you're getting heavy into Office Automation! Here are a few more sources for information:
>
>1. IntelliSense and the Object Browser in VFP 7. Use early binding with your variables, as in LOCAL oWord AS "Word.Application" and IntelliSense lets you know your choice of methods and properties. A terrific reason to upgrade to VFP 7.
>
>2. The MS KB has lots of info, too. Good stuff there. Start your search on "VFP Word automation" (or substitute Excel), and drop VFP if you don't get enough hits. Translating from VB isn't to hard (there's a good KB article on that one, too).
>
>3. The Solutions sample has some good code, too.
>
>4. Go to www.hentzenwerke.com and purchase "Microsoft Office Automation with Visual FoxPro." Tamar Granor and I wrote it, Ted Roche tech-edited it. It's packed with all kinds of code that's been tested in production apps. The best part of the book is that it's a .CHM file. Purchase it through Hentzenwerke and within a business day, you'll get an email telling you how to download the .CHM file, so you can start reading it before the hard copy shows up on your doorstep.
>
>HTH,
>
> - della