>>>>>In my reporting section, I'm giving a option of transferring reports to excel..
>>>>>
>>>>>Here, I am simply redirecting the output to a txt file and then starting excel with the txt file name as the command line parameter...
>>>>>
>>>>>I have questions for the same :-
>>>>>
>>>>>1. Is there any way I can retrieve the Path of Microsoft Excel, so I can provide it in the run parameter..
>>>>>as on every machine it is not sure that its installed in same dir..
>>>>>
>>>>>2. Is there any better way to do this whole thing...
>>>>
>>>>Look in the samples provided by MS, they are very help in this regard.. You will want to use OLE to try and strta up a copy of Excel, and if the BUILDOBJ() fails, they have NO Excel loaded..
>>>>
>>>>Thanx!
>>>>
>>>>Tony Miller
>>>>Vancouver, Wa
>>>
>>>Pls note that I'm Using VFP 3.0b, Can u pls tell me where is the example given for Excel ??
>>
>>Under samples, I do believe there is an example of OLE driven applications.. However, doing this under 3.0 is not as great as 5.0...
>>
>>
>>Thanx!
>>
>>Tony Miller
>>Vancouver, Wa
>
>Actually main problem is few of our machines are still running win 3.11, so have to stick with vfp 3.0b..
>
>Can u pls give me any tip/idea for vfp 3

If you do the following in the command window of VFP, you will be executing the Solutions demo included with VFP.. In there are code samples for working with OLE objects and VFP..

SET DEFAULT TO c:\vfp\samples\solution
DO solution.app


In there is code to handle the situation you have brought up..

Thanx!

Tony Miller
Vancouver, Wa