Search found 2 matches
- 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...
- 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
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