Microsoft KB Archive/70274

{| = PASTE.APPEND DDE Example Results in Error in Q+E Formula =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q70274

SUMMARY
On page 105 of the &quot;Q+E for Microsoft Excel User's Guide,&quot; there is a DDE example of using PASTE.APPEND. Each one of the EXECUTE lines requires an ending parenthesis, the documentation incorrectly leaves these out. If you do not include the closing parenthesis, you will get the Excel alert message &quot;Error in Formula&quot; upon typing any one of the lines.

MORE INFORMATION
The second example for the PASTE.APPEND function should read as follows:

=EXECUTE(chan,&quot;[open('emp.dbf','dbasefile')]&quot;) =EXECUTE(chan,&quot;[allow.edit(true)]&quot;) =EXECUTE

(chan,&quot;[Paste.append('Edward&quot;&CHAR(9)&&quot;Johnson&quot;&CHAR(9)&&quot;E98765')]&quot;) Note: The line beginning with (chan,&quot; is supposed to be on the same line as =EXECUTE. (chan&quot; is placed below =EXECUTE in this example because there is not enough room on the screen for the line to appear correctly.