Connector for Excel and the programming languages R and Julia
...It really could not be any easier. BERT also has a console that you can use to control Excel in real time, right from your R code. And (if you want), you can call R functions from VBA as well.