Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Controlling Excel97 from VFP5
Message
De
08/07/1999 07:53:14
 
 
À
08/07/1999 02:40:42
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00238364
Message ID:
00238755
Vues:
15
I've few questions related with excel & vfp...

1. Will this code work with Office 95 also ?? I'm transferring reports in excel but i want to keep my code portable so it can run in all versions..

Yes this code should work with Both versions of office


2. How to chk, whether user has installed office or not ?? (any version), If installed, which is the version ??

Try This

X = 0
* Turn errors off
On Error X = 1
loExcel = CreateObject("Excel.Application")

IF X = 1
* Excel Not Loaded on this machine
ELSE
* Excel is loaded on this machine
ENDIF

On Error

3. What is the best way to transfer data to excel i.e.
(a) copy to xls command
(b) copying to clipboard & pasting it


(3) oXls(row,col).value = ????
Number 3 is the best way I think. You have so much more control over the data

Thanks
Darren
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform