2.1: Automatically generate VBA code from Process Runner

 Previous  Home  Next

This option will work only for external excel files.

1.Select the External Excel File in which macro is to be created and click on Generate Template button in toolbar.

pror comm promp1

2.  Select 'Insert “Run with Process Runner” button to worksheet' option in Generate Excel Template screen.

pror comm promp2

➢Note:

a. The 'Insert “Run with Process Runner” button to worksheet' will not be altered until “Trust Access to VBA Project” is turned-on. Click on the “Click Here” link in pop-up window to know -how to do it.

b. Ensure to exit Process Runner before enabling 'Trust Access to VBA Project' as there will be an active excel instance due to inbuilt iBook- that will not allow the change in settings.

clip0013

 

c. Once 'Trust Access to VBA Project' is enabled and Process Runner is restarted, the 'Insert “Run with Process Runner” button to worksheet' can be turned-on.

clip0014

3.  Click on OK.

hmtoggle_plus1Conclusion

1. Following the above steps will lead to insertion of VBA macro button displayed as "Run with Process Runner" in the excel file.

clip0015

 

2. The code can be exhibited through Visual Basic Editor.

clip0016

 

3. Following is the code that will be automatically included 'Run with Process Runner' button- with macro.

clip0018

Note: The above code snippet will enable you to run Process Runner through VBA-Excel.

 

 

Next:

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