BERT
Connector for Excel and the programming languages R and Julia
...Everything else – loading the function into Excel, managing parameters, and handling type conversion – is done automatically for you. 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.