DDEExecute

[daniel massi]

Parameters in a DDEExecute :
In the Help file, we have :
DDEExecute Channel:=lngChannel, Command:="[Run(" & Chr(34)
& "Personal.xls!Macro1" & Chr(34) & ")]"
But how add two or more parameters to launch this macro.
Example : copycells(startcells, aimcells).
The ( ) characters arn't accepted !
Thank you

 

[Cindy M -WordMVP-]

Hi Daniel,

1. This is a Word group, you're asking a question about
automating Excel.

2. DDE only works with the old macro languages, XLM in the
case of Excel, and in those languages, .Run accepts no
parameters

3. You need to write the information somewhere, like to a
text or INI file, then have the macro in Excel read it

Parameters in a DDEExecute :
In the Help file, we have :
DDEExecute Channel:=lngChannel, Command:="[Run(" & Chr(34)
& "Personal.xls!Macro1" & Chr(34) & ")]"
But how add two or more parameters to launch this macro.
Example : copycells(startcells, aimcells).
The ( ) characters arn't accepted !

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail