Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Example of Excel using VFP COM?
Message
From
14/10/1999 08:38:38
 
 
To
14/10/1999 07:25:50
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00276233
Message ID:
00276258
Views:
31
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
Previous
Reply
Map
View

Click here to load this message in the networking platform