How does this DDE Execute works..?
I want to open a program and open a file..
and then let it auto-edit it..with a macro. Is this possible?
In my case it is Excel and then let it import a textfile, and then a macro
to seperate the words.

grtz RickFM

DDE is a bit old hat and not that easy to work with. Easier to either (1)
write a VBS script to do what you want, then use FM's Send Message script
step to fire the VBS, or (2) arrange an Excel auto-starting macro to do all
you need, then use Send Message script to run Excel, with the the .XLS file
name as a parameter: e.g. "c:\wherever\msoffice\exel.exe e:\your_dir
\yourfile.xls"

--
Regds, Bob Osola

Should have added a demo: lets say you have an Excel file called
somestuff.xls in folder c:\my folder which has a macro called DoSomething.
The following trick will open the file and run that macro automatically:

Copy the following 4 lines and save in Notepad to a file called (say)
RunExcel.vbs in (say) c:\scripts. The file MUST have the .vbs suffix.

'----
Set objXL = WScript.CreateObject("Excel.Application")
objXL.visible = true
objXL.workbooks.open "c:\my folder\somestuff.xls"
objXL.run "somestuff!DoSomething"
'----

All you then do is create an FM script using the Send Message step. Put the
path to the VBS file in the text box (including the quotes):
"C:\scripts\RunExcel.vbs"
and also untick Bring Application to Foreground.

When you run the the FM script, FM will fire off the VBS file which in turn
opens the Excel file and runs the macro. Just change names/paths to suit.

--
Regds, Bob Osola