Microsoft KB Archive/91704

{|
 * width="100%"|

Excel: DDE Name &quot;Microsoft Word&quot; Does Not Work

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 3.0, 4.0

-

SUMMARY
In versions 3.0 and 4.0 of the &quot;Microsoft Excel Function Reference,&quot; the dynamic data exchange (DDE) name used for Microsoft Word for the Macintosh is incorrect. Macro examples for the INITIATE function use &quot;Microsoft Word&quot; as the DDE name for initiating a channel to Microsoft Word. This results in the following error message:

&quot;Cannot find data source&quot;

The correct DDE name for Microsoft Word is &quot;Word.Document.6&quot; (for Microsoft Word version 6.0) or &quot;WordDocument&quot; (for versions of Microsoft Word earlier than version 6.0).

MORE INFORMATION
The INITIATE function opens a DDE channel to another application. App_text, the first argument of the INITIATE function, is the DDE name of the application with which you want to begin a DDE session.

The following macro statement initiates a channel to a document named &quot;Untitled1&quot; in Microsoft Word for the Macintosh:

  =INITIATE(&quot;WordDocument&quot;,&quot;Untitled1&quot;)

Note that if you are using Microsoft Word 6.0 for the Macintosh, use the &quot;Word.Document.6&quot; argument.