If I use the statement below to read a formula containing a DDE link, I get an incorrect result:
strFormula := XLS.Sheets[SheetIx].AsFormula[Col, Row];
Expected:
server|topic!'item'
actual:
server|topic!item (without the quotes)
To fix the problem, I created an override for the GetName function in TExtNameDDE like this:
function TExtNameDDE.GetName: WideString;
begin
Result := #39 + CompressedStrToWideString(FName) + #39;
end;
Trond