We can call any Process through a VBA macro with the help of the VBA Shell function and the WinAutomation Controller.
The code we have to enter in the VBA macro is the following
Dim RetVal As Variant Dim WA_ProcessName As String Dim Start_WA_Process As String WA_ProcessName = "<Your_Process_Path>" Start_WA_Process = Chr(34) & "C:\Program Files\WinAutomation\WinAutomationController.exe" & Chr(34) & " /start " & Chr(34) & WA_ProcessName & Chr(34) RetVal = Shell(Start_WA_Process, 1)
You can try this with the attached files.
Download the "Hello.waj" and import it in the "My Processes" folder in the WinAutomation Console. Afterwards download the .xlsm file, open it and click the "Run WA Process" button.
In this example the variable WA_ProcessName would get the value
WA_ProcessName = "/My Processes/Hello"