DDE EXIT() Returns #VALUE! Error Value (108723)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Query
This article was previously published under Q108723 SYMPTOMS
When a macro initiates a DDE channel to Microsoft Query and sends the
EXIT() command from within the EXECUTE() function, the command will be
evaluated to a #VALUE! error value.
When you have a query open in Microsoft Query, the application will not end
and will evaluate to a #REF! error value. Using the EXIT(TRUE) function
will always end Microsoft Query and evaluate to the #VALUE! error value.
EXIT() or EXIT(FALSE) will close Microsoft Query only if there are no open
queries that were opened on another channel.
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB108723 |
---|
|