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"")]"