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