can procomm run an excel macro

[hawk1996]

Is there a way to have a procomm script run an excel macro?
I can get it to open an excel worksheet by using the run command, but can it also run a specific macro?

Thanks

 

[knob]

Here is a sample script that shows how to run a macro called Macro1:

proc main
long LinkVar, SystemVar ;Variables containing DDE Id's.

;Set up DDE links to Excel's system and a spreadsheet. Excel
;must be running in order for this script to work properly.
if ddeinit SystemVar "excel" "system"
ddeexecute SystemVar "[FULL(TRUE)]" ;Maximize the spreadsheet.
if ddeinit LinkVar "excel" "sheet1" ;Set up link to spreadsheet.
ddeexecute LinkVar "[RUN(`"Macro1`")]"
ddeterminate LinkVar ;Break DDE link to spreadsheet.
ddeterminate SystemVar ;Break DDE link to Excel.
else
errormsg "Couldn't establish DDE link to spreadsheet!"
endif
else
errormsg "Couldn't establish DDE link to Excel!"
endif
endproc

http://www.aspectscripting.com

 

[hawk1996]

Thanks, that works great. One other question, can you have procomm yield until the macro finishes.

 

[knob]

Unfortunately, I don't know if this can be done since it is not clear to me if Procomm waits for the DDE server to return its status, or if Procomm posts success when it sends the message to the server.

http://www.aspectscripting.com

 

[hawk1996]

Thanks anyway knob, I'll just put a usermsg in there telling the user to wait until the macro finishes.