Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Running Microsoft Excel from VFP
Message
De
28/12/1997 09:30:06
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordanie
 
 
À
28/12/1997 00:07:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00067923
Message ID:
00068137
Vues:
26
>>>>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
Fil
Voir

Click here to load this message in the networking platform