General information
Category:
COM/DCOM and OLE Automation
Title:
Calling VFP from Excel
I'm trying to write a macro in Excel which will run a DLL written in VFP.
So far, I can instanciate a VFP object and run the VFP method from within the Excel macro, but I'm running into problems and have the following questions :
1) When ever I try to pass parameters or return a value from the VFP method, I received a Run-time error '107'.
2) Is there a way in Excel to run a macro directly from a cell on the spreadsheet such that it returns a value directly into the cell?
3) Is there a way within an Excel macro to pass an object reference of the active Excel worksheet to the VFP DLL?
Any help would be greatly appreciated.
Anthony Letts
Next
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