Microsoft KB Archive/67442

{| = Terminating a Channel with Q+E Closes the File =
 * width="100%"|

Last reviewed: November 4, 1994

Article ID: Q67442 The information in this article applies to:
 * Microsoft Q+E for Microsoft Excel, versions 2.1, 2.5 and 3.0

SUMMARY
When a file is the topic of a DDE channel to Microsoft Q+E or a file is opened over a channel initiated with the topic &quot;system&quot;, that channel will close the file if you issue a terminate.

Workaround
Save the query before terminating the channel. This allows you to reopen the query in Q+E.

MORE INFORMATION
The following macro opens EMP.DBF, selects all employees hired after 1/1/85, and then saves the query as TEST.QEF. You can then move to Q+E and open TEST.QEF to view only employees hired after 1/1/85.

chan=INITIATE(&quot;QE&quot;,&quot;SYSTEM&quot;) =EXECUTE(chan,&quot;[open('c:\excel\qe\emp.dbf','dBASEfile')]&quot;) =EXECUTE(chan,&quot;[select.column(hire_date)]&quot;) =EXECUTE(chan,&quot;[add.condition(1,5,'1/1/85',FALSE)]&quot;) =EXECUTE(chan,&quot;[save.query.as('test.qef')]&quot;) =TERMINATE(chan) =RETURN
 * }