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