Hi All,

I am new in Excel, but I have some experience in general programming. I

have a problem with DDE dynamic formulas.

I have an application that maintains templates of Excel Formulas in SQL

Server. What I need is to load these formulas in Excel and evaluate
them.

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 !!!!

To load the formulas from SQL Server is simple I have already done it.
The
problem:

- How to contruct the formula dynamically
- How to evaluate it so that it is refreshed as their value changes in

the server

Thanks in advance


--
MArcus Baffa
------------------------------------------------------------------------
MArcus Baffa's Profile: http://www.excelforum.com/member.php...o&userid=36344
View this thread: http://www.excelforum.com/showthread...hreadid=561295