Use Dynamic Data Exchange (DDE) with Microsoft Query

Some of the content in this topic may not be applicable to some languages.

Microsoft Query supports Dynamic Data Exchange (DDE), a form of communication that allows two programs to exchange data with each other. You can use DDE methods in Visual Basic for Applications to communicate and send data back and forth between Microsoft Query and another program, such as Microsoft Excel.

Learn more about how to use DDE

Open a DDE channel

Execute DDE commands

Learn about the available DDE commands

Request status and other information

Retrieve data

Exit Microsoft Query from DDE

Close a DDE channel

Use Microsoft Query with other programs