2.2: Step-by-Step on manually generating VBA Code for Process Runner

Users can run Process Runner through VBA-Excel. The following guidelines will lead to generate VBA code manually- for the Process Runner.

Note: If the developer tab is absent, Right-click anywhere on the excel toolbar --> Customize Ribbon --> check the 'Developer' option from the right panel under main tab.

3.Select 'Button' control option from 'Developer Tab' as highlighted in the image below.

4.Draw the button on the excel sheet using the selected button tool. You will automatically get a prompt of Assign Macro. Click on OK.

Sub btnProrExecute_Click()

Dim ProRPath As String

Dim ProcessFilePath As String

Dim CmdParam As String

Dim ShowMsg As String

'=== Process Runner Parameters ====

'ProR: Name of the Process Runner exe in installation folder.

** Second parameter is the path of Process Runner file that you want to run.

'|AutoRun: Specifies whether you want to autorun file on opening. This would require you to also assign Logon file (explained next) as an additional parameter.

'|LogonFile: name of the Logon file to be used.

'|ExcelFile: Complete path of the external excel data file to be used with the Process file.

'|StartRow: Start row to be taken for the file mentioned in |ExcelFile parameter.

'|EndRow: Specifies the end row to be taken for the file mentioned in |ExcelFile parameter.

'=== Process Runner .exe file path ===

ProRPath = "C:\Program Files (x86)\Innowera\Process Runner\ProR.exe"

'=== Process file path ===

ProcessFilePath = "C:\Users\TestUser\Documents\Innowera\ProcessFiles\MM02_Change_Material.itf"

'=== Make full command parameter to execute Process Runner with process file ===

CmdParam = Chr(34) & ProRPath & Chr(34) & " " & Chr(34) & ProcessFilePath & Chr(34)

ShowMsg = "Do you want to run current Excel file with Process Runner?" & vbCrLf & vbCrLf & "This Excel file will be executed with " & ProcessFilePath

If MsgBox(ShowMsg, vbYesNo + vbQuestion) = vbYes Then

CmdParam = CmdParam & " " & Chr(34) & "|ExcelFile=" & ThisWorkbook.FullName & Chr(34) & " " & _

Chr(34) & "|AutoRun=true" & Chr(34) '& " " & _

' Chr(34) & "|LogonFile=<LogonFileName>.ilf" & Chr(34) & " " & _

'Chr(34) & "|SheetName=Sheet1" & Chr(34) & " " & _

'Chr(34) & "|StartRow=2" & Chr(34) & " " & _

'Chr(34) & "|EndRow=30" & Chr(34)

'=== Execute ===

Shell CmdParam, vbNormalFocus

End If

End Sub

11. Ensure to check Macro Security Settings (Developer --> Macro Security) before Run as it will determine your Macro execution level.

The above steps conclude VBA through Process Runner. Process Runner can also be executed from Dos Command Prompt which gives a brief overview on the various command line parameters that Process Runner accepts.