Consultor Eletrônico

DDE Command list for EXCEL 5. Where to find it?

Where to find a list of DDE comand (or list of atoms) that can be used
with EXCEL 5:


Check the following in the on-line help of EXCEL 5:
---------------------------------------------------

In the menu help choose content
-> Reference informations
-> General reference: Microsoft Excel Macro Functions Contents
-> Macro functions listed by category

Good places to look at are ...
- Command-Equivalent
- DDE/External

And some others probably ...

But there are some tricks and tips ...
-----------------------------------------

For instance if you go to:
in the menu help choose content
-> Reference informations
-> General reference: Microsoft Excel Macro Functions Contents
-> Alphabetical List of Macro Functions

There you will find the 'windows' macro command.

Here is a short description of that command:
"That command returns the names of the specified open Microsoft Excel
windows, including hidden windows. Use WINDOWS to get a list of active
windows for use by other macro functions that return information about
or manipulate windows, such as GET.WINDOW and ACTIVATE. The names are
returned as a horizontal array of text values, in order of their
appearance on your screen. The first name is the active window, there
next name is the window directly under the active window, and so on."

As You can see this command returns a list of names. Thus it is not
possible to use it directly in your PROGRESS application, because
PROGRESS can not handle the result of that atom send to EXCEL via a
DDE execute command. The only way to use that function in a DDE link,
is to store the result of that atom in an EXCEL cell and then with a
DDE get statement pass that information back to PROGRESS.

Note:
----

There might be some other tips and tricks that are not referenced here
for those functions. If you encounter some please contact us to update
this Knowledge base entry.

Progress Software Technical Support Note # 16475