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”)]’)