Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formula in excel sheet can return values computed by fo
Message
De
30/05/1998 16:28:24
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00103367
Message ID:
00103396
Vues:
29
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform