The below reference will explain you the step-by-step on how to RUN Process Runner through VBA.
For this we will be covering 3 chapters:
Chapter 1: Executing Process Runner with Command Line Parameters
This chapter will give a brief overview on the various command line parameters that Process Runner accepts.
Chapter 2: Executing Process Runner from command line through Excel-VBA
This can be done in two ways:
2.1 Automatically generate VBA code from Process Runner:
2.2 Step-by-step on manually generating VBA code for Process Runner:
This will cover the entire process of creating a VBA macro in Excel to start Process Runner. There is also sample code inside for your ready reference.
Chapter 3: How to enable Trust Access to VBA Projects
This explains the security checkpoint that user needs to do in order to use the recent (available from version 4.10 onwards) generate template feature of Process Runner.