>>>>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 ??
>
>You could also do the following: Use a routine to parse thru your system.ini file and find the path to excel in that..
>
>I would also look at excel opening up a DBF file as apposed to a text file...
>
>Thanx!
>
>Tony MIller
>Vancouver, Wa
Regarding DBF file, I know its better to have that instead of TXT,
I'll try to change my program..
Re scanning the ini files, I'll try to use this method and the create object method (which is advsd. to me) & see which one works better..
Thanks !!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement