Hi Jozef ---
Yes. Tie the CreateObject and GetValue() methods into a macro. That way, the user can type "Alt+V" or whatever you deem appropriate and put the value in there. It is the end value you want, right?
>I need solution that is transparent to user. With using DDE, excel user can simply write formula " =appsevice|topic!item " and when my appliction is runnig
>excel display proper values. Can I simulate this by using OLE server i VBA ?
>
>>
>>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