>>>>>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...
>>>>Check for OLE automationin help and solutions sample and createobject, getobject etc.
>>>>Cetin
>>>
>>>Pls note that I'm Using VFP 3.0b, Can u pls tell me where is the example given for Excel ??
>>And an addition here. You don't need to know the path to Excel, registry knows it. Just create or get your object. If you fail there then Excel is not installed (at least correctly).
>
>Thanks a lot..
>
>I will try your suggestion..
>
>Will it work for both ( I mean win 3.1 & win 95) ??
Yes it will. It would be the case for excel or another registered app. For example you could have many image processing programs installed on your machine and when you double click on a bmp object the one associated with BMP is called unless overridden and it doesn't need to be in path (DOS path is limited in length). For XLS files excel wouldn't be activated by dblclick if that type is associated with some other app and still createobject and getobject would find it through registry (except incorrect installation).