Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Streaming data into Excel
Message
De
21/12/2006 09:04:07
 
 
À
21/12/2006 03:52:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01179463
Message ID:
01179530
Vues:
9
>Hi All
>
>Years ago I used DDE to return data into Excel. A user would type in a formula in Excel which would then connect to my app running in the background using DDE. My app would then send back the data requested. But more importantly when my app got new data in it would send it back to Excel again and again.
>
>What would be the best approach to doing this today keeping in mind (a) unsophisticated users who do not want to do things very much differently today and (b) that my app must be aware of all Excel cell's that have requested some data so that it can re-send new data as it comes into my app.

The best way is to use Excel VBA:
oMyexcel=createobject('Excel.Application')
oMyexcel.visible=.t.
oMyexcel.workbooks.add
and then you use all MS-Excel VBA methods/properties to move Fox data to Excel cells.
Btw, you are not required to set Visible=.T. so all processing will happen on background.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform