Information générale
Catégorie:
COM/DCOM et OLE Automation
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
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