Hi John !
Thanks for your answer.
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 ?
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement