Show AllShow All

Fetch and Fetch.Advise Commands (DDE)

The Fetch command retrieves data from Microsoft Query and sends it directly to the destination program.

The Fetch.Advise command updates the destination program automatically as values in Microsoft Query change, not just when the Fetch.Advise command is sent.

These commands are available on both the system channel and the query channel.

Syntax 1

Fetch.Advise(appname, topic, range, values)

Syntax 2

Fetch(appname, topic, range, values)

appname The name of the destination program to which the data is to be sent. Here are the appname arguments you'd use for Office programs:

Program Value of appname
Microsoft Access MSAccess
Microsoft Excel Excel
Microsoft Word WinWord

topic The name of the worksheet, document, or control to which the data is to be sent.

range The area of the worksheet, document, or control to which the data is to be sent.

values The values to be retrieved from Microsoft Query. (For valid values, see the table below.)

Note  The Fetch.Advise command automatically updates only query data, not request items or row#col# references.

Can be one of the following values:

Value Description
Request_item The information to return; for example, QueryDefinition.
row#col# A reference to retrieve specific rows and columns, such as R3C5 from Microsoft Excel.
/Headers Retrieves column names.
/Rownum Retrieves row numbers.
All Retrieves all records.

Remarks

For Fetch.Advise, the channel created to return data to the destination program isn't closed until a Fetch.Unadvise or Close command is sent.

Example

This example uses the NumRows and NumCols request items to return the number of rows and columns in the query, and then returns the values with column headings to a Microsoft Excel worksheet named "Sheet1."

rows=REQUEST(Chan,"NumRows")
cols=REQUEST(Chan,"NumCols")
DDEExecute chan, "[Fetch(""Excel"", ""Data.xls!Sheet1"", _
    ""R1C1:R"&rows&"C"&cols&""", ""All/Headers"")]"