CODEWITHSUNDEEP
vbarstudio
Matan Sheffer
Matan Sheffer

Reputation: 123

Running RScript in VBA

I'm trying to create a VBA script that run RStudio script.

i tried using the Shell() command or the Run oShell at VBA, but the best thing i mange on doing is open the RStudio script, not making it to run automatically.

By the way, the RStudio script create a csv file which i will use. this is the VBA script i use right now:

Sub RunRStudio()

Dim path As String

path = ThisWorkbook.path & "\Test.R"

Set oShell = CreateObject("WScript.Shell")

oShell.Run "RStudio " & path

shell ("RStudio " & path)

End Sub

How can i run this RStudio script automatically from VBA?

Thanks.

Upvotes: 1

Views: 1229

Answers (1)

NoeliaNC
NoeliaNC

Reputation: 11

I had the same problem. Thank you, because your code helped me to find the solution.

This code, with a little change, it works to open the window of Rstudio, but it doesn't work to run the script. You need to use "RScript", not "RStudio".

You can try this to run your code:

    Sub RunRTest()

    Dim path As String
    path = """C:\Program Files\R\R-3.5.2\bin\RScript.exe"" 
    ""C:\Folder\YourScriptName.R"""

    Set oShell = CreateObject("WScript.Shell")
    oShell.Run path

    End Sub

Or:

    path_file = ThisWorkbook.path & "\YourScriptName.R"
    path = """C:\Program Files\R\R-3.5.2\bin\RScript.exe"" " & path_file & ""

if you have the path of your file in other var.

I hope to help someone!

Upvotes: 1

Related Questions