DDEAppReturnCode Property
Returns the application-specific DDE return code that was contained in the last DDE acknowledge message received by Microsoft Excel. Read-only Long.
Example
This example sets the variable appErrorCode to the DDE return code.
appErrorCode = Application.DDEAppReturnCode