Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Example of Excel using VFP COM?
Message
De
14/10/1999 08:38:38
 
 
À
14/10/1999 07:25:50
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00276233
Message ID:
00276258
Vues:
30
Hi

you would hace to use VBA to create the vfp com object, I think it is much the same syntax as the create object in vfp.

The com object could be called from within a macro, or if you are using a later edition of excel, called from within a VBA module, if you have a later edition of excel run the visual basic tool bar, then create a new module.

once the com object is created you could then use the object model of excel to populate the required cells with the data retrieved from the com object.

excel has a method which run every time you start an instance of excel, I think it is called atuo open, you could create the com object in here, then release the com object when you close the work book, or exit excel.

Hope this helps

Steven Bowskill
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform