Search found 2 matches

by tgr
Fri Jan 09, 2009 12:43 pm
Forum: XLSReadWriteII 3/4/5
Topic: Error reading a formula containing a DDE link
Replies: 0
Views: 2363

Error reading a formula containing a DDE link

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 T...
by tgr
Tue Jan 06, 2009 12:50 pm
Forum: XLSReadWriteII 3/4/5
Topic: 'Unknown name' error when inserting a DDE link
Replies: 0
Views: 2162

'Unknown name' error when inserting a DDE link

Hi,

I am trying to insert a DDE link in my Excel sheet with this code:

XLS.Sheets[0].AsFormula[Col, Row] := Format('%s|%s!''%s''', [DdeServer, DdeTopic, DdeItem]);

But this results in an 'Unknown name' error message.
What do I need to do to fix this?

Thanks, Trond