VBA to R and Back Again: Running R from VBA

Introduction

Today I am going to briefly go over an extremely simple example of running some R code via Excel VBA.

Let’s start by discussing each line of code one by one:

Sub CallRnorm()

This line defines a subroutine called “CallRnorm”. A subro...