DDE Execute? 
Author Message
 DDE Execute?
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



Tue, 04 Nov 2003 16:32:46 GMT
 DDE Execute?



Quote:
> 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.

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



Wed, 05 Nov 2003 16:21:26 GMT
 DDE Execute?


Quote:
> 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,

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



Fri, 07 Nov 2003 04:28:29 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. VB DDE execute in ACCESS

2. dde.execute

3. Send DDE Execute

4. Filemaker Pro DDE Execute to export to Word

5. about Send DDE Execute

6. Send DDE Execute - Valid Service Names

7. dde execute -> excel

8. DDE Execute-->Excel

9. DDE execute

10. Send DDE Execute

11. DDE Execute Time-Out

12. DDE Execute...


 
Powered by phpBB® Forum Software