Has anyone found the missing in action Microsoft documentation that describes what return values are valid from the Application.DDEInitiate method. In particular, is the value 0 an error, or is it a valid DDE channel number?

As an extra added bonus challege, I wonder if anyone here knows how one can test for the success of the DDEInitiate method, and recover from a possible error gracefully. There is no mention in the Microsoft documentation (at least that which I have) of it throwing any exception or error condition in VBA.

{ OK , I answered the second one for you: (a) turn off user alerts, (b) activate your On Error handler, and (c) Err = -2147352531 (that's hex 80020005) means that your requested DDE server could not be found nor started by Windows. Now how about the first easy question? }

Many thanks in advance.