0

What arguments should I type after CMD BATCH args to produce an output file called my file.log?

Dim shell As Object
    Set shell = VBA.CreateObject("WScript.Shell")
    Dim waitUntilComplete As Boolean: waitUntilComplete = True
    Dim errorCode As Long
    
    errorCode = shell.Run("""C:\Program Files\R\R-4.1.1\bin\x64\R.exe""" & " CMD BATCH --vanilla " _
                & """--args C:\MyProject\RInt.xlsm"" " & """C:\MyProject\RunAll.R""", vbHide, waitUntilComplete)

0

Browse other questions tagged or ask your own question.