>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