Very Computer

Hi everyone,

Does anyone know where the documentation is that specifies all the
commands that can be sent to Excel via a DDE conversation?

for example I can send the following code (DELPHI) to the program
manager in Windows 3.x to create a new program group :

        DDEClientConv.ExecuteMacro('[CreateGroup(Phony Group)]',true)

but I need to find a list of the commands I can send to Excel.

TIA.

Phil
--
/----------------------------------------------------------------\
| Phillip Middlemiss            | 2 wrongs don't make a right... |
| NZ Forest Research Institute  |                                |

\----------------------------------------------------------------/

Hi Phil!

When you initiate a DDE conversation with Excel, you can send commands to
Excel in the Excel 4.0 macro language (or XLM).  If you are unfamiliar
with XLM, you can record actions in Excel to get the equivalent XLM
commands.  To record a macro in Excel, choose Tools > Record Macro >
Record New Macro.  In the dialog box that appears, press the Options
button and select the language "Microsoft Excel 4.0 Macro" and then click
OK to begin recording.

Excel 5.0 comes with a help file that describes all of the XLM commands
and arguments; however, Excel 7.0 does not include this help file but it
can be downloaded from http://www.microsoft.com/kb/softlib (the file name
to download is macrofun.exe).

Thanks, Lori Turner

Microsoft Excel
Answerpoint Support

=========================================================================
The Microsoft Newsgroups are LIVE at http://www.microsoft.com/support
The Microsoft Knowledgebase is available on the Internet at
http://www.microsoft.com/kb/
The Microsoft Software Library is available on the Internet at
http://www.microsoft.com/

Quote:>Does anyone know where the documentation is that specifies all the
>commands that can be sent to Excel via a DDE conversation?

>for example I can send the following code (DELPHI) to the program
>manager in Windows 3.x to create a new program group :

>        DDEClientConv.ExecuteMacro('[CreateGroup(Phony Group)]',true)

>but I need to find a list of the commands I can send to Excel.

  Help
    Contents
      Reference Information
        Microsoft Excel Macro Functions Contents

which will give you pretty much the same list - sorry I don't use Excel7.0
because I don't like the Excel7.0 Help structure, but the equivalent may
be in their someplace.

I cannot seem to find the CreateGroup function you are using from Delphi
listed, but I have had success using some of the other Excel4.0 macro
functions through DDE.

Hope this helps.