General information
Category:
COM/DCOM and 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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only