Hi Jozef!
What you need is to create an OLE server in Fox with a method that returns the computed value ... then, in Excel, (after you've compiled and registered the server) you create an instance of the Fox object by using the VB CREATEOBJECT command to create an instance of the server and then call the method
Set oTest = CreateObject("FoxOLEServer")
x = oTest.GetValue()
Read Chapter 16: Adding OLE in the VFP Online Documentation for more details.
>Hi everybody !
>User of my accounting aplication want to use values computed by this aplication while working in excel and simply writing a formula into sheet cell. I think that it is possible by DDE or OLE, but before I start I need some suggestion, how to do it and what is better OLE or DDE.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05