>We have a project that requires some functionality of excel, word, and powerpoint. These functionalities should be achieved w/o activating the word/excel/powerpoint system itself but all by programmatic. Can we do it in VFP or we should look into VBA? Any inputs is highly appreciated.

Get the sample code from my website. It was written by Randy Brown of the MS FoxPro Team. It has an example using Word, Excel and Powerpoint.