Using DDE with Excel

[az1455]

Is there a way start a macro in MS Excel using DDE from Procomm. Thanks

 

[knob]

http://support.microsoft.com/support/kb/articles/Q143/4/66.asp

is an Excel 97 help file that may have the proper command to send Excel to run a macro. Hank posted this link a while back and may have a better answer when he sees your message.
aspect@aspectscripting.com

http://www.aspectscripting.com

 

[knob]

Also, there are a couple sample scripts (from Hank) on my site that show how to interface with Excel using DDE if you need help getting that part written. aspect@aspectscripting.com

http://www.aspectscripting.com

 

[hankm3]

Hello,

Once you establish your Links to the Excel Spreadsheet that contains the Macro, you use the following command:

ddeexcecute LinkVar "[RUN(`"Sheet1.Macro`&quot]"

Hope this helps.

Hank
camphm@bellsouth.net

 

[az1455]

Thanks for the help. This is what I needed.