View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default How to Evaluate Dynamic DDE Formulas

MArcus Baffa wrote...
....
These formulas are, in fact, DDE Links to a resource server. The
resource values are updated as they change, and I need that the loaded formulas
respond to the DDE advise event. That is they should change continuosly as
the resource changes.

And more some formulas must be contructed based on a specific cell. For
instance Column 1 has the name of the resource, so the DDE Link formula in
column 2 must be of type =appserver|topic!&CONTENTS OF ("C1").

Well if I manually put the formulas in a cell like "=app|topic!item"
they work. The Server is working OK !!!!

....

You've come across one of the archaic deficiencies of Excel. DDE links
in cell formulas can only be static, that is, =app|topic!item. You'd
need to use VBA to make them function dynamically, and that involves
using user-defined formulas (udfs) in VBA to create another Excel
application instance, construct static DDE link formulas and evaluate
them in the other instance, then return their values to the calling
instance. It's slow and relatively fragile.

Can you use VBA to do this?