What is the best way to run R code within a VBA routine?

Question

JE

Analyst

What is the best way to run R code within a VBA routine?

Asked over 5 years ago

The data that I work with often is coming out of Excel and for now, we run some VBA, then run some R, then run some VBA, and we would like to fully automate this process.

Statistical Analysis Software

Comment

1 comment

1

Looks like you’re not logged in.

Users need to be logged in to answer questions

Log In

Pascal B. · Answer 1 · 2020-03-19T17:04:38-05:00

PB

Pascal B.

Senior Reliability Analyst chez Centre of Expertise for Maintenance and Reliability at Cascades Canada ULC

0

Answered almost 5 years ago

I ran into same kind of problems. Then I discovered PowerBI. With PowerBI, and the help of PowerQuery, I'm getting rid of all VbA engines to process data. I tried like you to find a way to make this work in Excel but Microsoft clearly does not want you to do that in Excel. They want to sell PowerBi and honestly, after following their workshop "Dashboard in a Day" I don't see why I would go back to Excel. I'm not completely sold to Microsoft and have been for a long time an RStudio adept. But this time, I think MS hit a homerun. Best data wrangling tool I've seen for a long time and a very fast learning curve if you already know Power Query from Excel.

What is the best way to run R code within a VBA routine?

About Posit