I have tried several examples found on forums to run my R script from VBA, but it doesn’t work. The R script works well alone. Here is the code I ran:
Sub RunRscript() Dim shell As Object Set shell = VBA.CreateObject("WScript.Shell") Dim waitTillComplete As Boolean: waitTillComplete = True Dim style As Integer: style = 1 Dim errorCode As Integer Dim path As String path = "RScript C:UsersDocumentsCode.R" errorCode = shell.Run(path, style, waitTillComplete) End Sub
I’m getting an error message saying that running object “IWshShell3” failed. Is there anything special to write on the R code prior to running this macro? Shall I load a package, or load the files in a specific folder?