>A friend of mine here (NOT ME!! Heheheh) needs a definitive list of Excel Macro keywords and maybe some code samples to create and format an Excel Spreadsheet (2000) through VFP 7.0.
>
>Any good websites with this info???

Hi Tommy,

All of the Excel documentation is online at http://msdn.microsoft.com/library. From the tree on the side choose Office Solutions Development > Microsoft Office > Microsoft Office XP > VBA Language Reference > Microsoft Excel Visual Basic Language Reference.

You can also direct him to Tamar and Della's book, "Office Automation with Visual FoxPro," available from http://www.hentzenwerke.com/catalogpricelists/autofox.htm.

Finally, he needs to open Excel and record macros of the types of things he wants to do, and then view the macros in the VBA editor. He can use that code as the basis of his Fox code and can then post with specific questions on things he has trouble with.

Another very helpful approach when working with automation code is to instantiate the Excel object in the Command window, make Excel visible, and then try different commands. Intellisense helps a lot too!