KB-28982: Executing an Excel macro via Elipse SCADA.

Question:

Can I execute an Excel macro via Elipse SCADA?

Solution:

Yes, you can. To do so, you must use DDEExecute (server, topic, command) function, where:

• server: name of the DDE server.
• topic: document open in the application.
• command: command you want to execute.

Example of script:

       DDEExecute(“Excel”, “System”, ‘[Run(“MacroName”)]’)