I would like to be able to allow the user to enter a custom formula in a cell in Excel, which will subscribe to the data provided by an external .NET application. For example, a user might enter ...
=getCurrentValue("ABC")
There is an external .NET application (C #) that determines the value of "ABC" every minute.
The cell should display the initial "ABC" value from the external application and update when the external application sends the new value.
In the past, I think the external application will be a DDE server, and the formula will be a DDE client, but DDE seems to be dead. What βrightβ technology is used for this?
Please note that the spreadsheet must retrieve the data using the formula The information is not included in the file with the corrected template, but in any spreadsheet into which the user enters the formula.
Thanks,
John
source share