Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Commands
Where does one get a list of DDE commands for Excel?
I am in need to Add a Worksheet, Change the names of Worksheets, and change the color of Cells via DDE. Can anyone provide me with the need information or provide me with a link. Thanks In advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Commands
the old xl4macro commands are the commands for DDE.
html help format: http://office.microsoft.com/downloads/2000/Xlmacro.aspx Either of these: http://support.microsoft.com/default...85&Product=xlw Macrofun.exe File Available on Online Services xl97 (old winhelp format) http://support.microsoft.com/default...66&Product=xlw XL97: Macro97.exe File Available on Online Services xl97 (old winhelp format) -- Regards, Tom Ogilvy "Newby" wrote in message ... Where does one get a list of DDE commands for Excel? I am in need to Add a Worksheet, Change the names of Worksheets, and change the color of Cells via DDE. Can anyone provide me with the need information or provide me with a link. Thanks In advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Commands
Hi,
I don't know of any DDE-Command list but from what i have read, the excel dde commands match closely the Excel 4.0 Macro language. - To get the help-file for the Excel 4 macro language , search Microsoft Dowloads for the Macrofun.exe file - build a macro similar to: Sub testDDE() Dim channel As String channel = DDEInitiate("Excel", "System") Application.DDEExecute channel, "[open(""c:\mybook.xls"",,FALSE)]" Application.DDEExecute channel, "[workbook.insert(1)]" Application.DDEExecute channel, "SELECT(!$A$1:$D$10, !$A$1)" '... Application.DDETerminate channel End Sub I hope this helps a bit. Regards, Sébastien <http://www.ondemandanalysis.com "Newby" wrote: Where does one get a list of DDE commands for Excel? I am in need to Add a Worksheet, Change the names of Worksheets, and change the color of Cells via DDE. Can anyone provide me with the need information or provide me with a link. Thanks In advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA commands | Excel Discussion (Misc queries) | |||
IF commands | Excel Worksheet Functions | |||
DDE Commands | Excel Discussion (Misc queries) | |||
DOS commands | Excel Discussion (Misc queries) | |||
MS DOS Commands | Excel Programming |