View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JessicaRowe JessicaRowe is offline
external usenet poster
 
Posts: 2
Default Evaluating a DDE formula created by strings

Function GetValue(App as String, Topic as String, Field as String) As
String

Dim command as String

command = "="&App&"|"&Topic&"!'"&Field&"'"

GetValue = command

End Function

So then I type in Excel, =GetValue(App,Topic,A1)

And great! The Cell showed =APP|TOPIC!'(Value of cell A1)'

However, how can I get Excel to evaulate the formula, instead of
showing the formula as a string?