I have the following problem that I hope someone knows the solution of.
First, I open a command window from VBA by
strPrgm0= "C:\WINDOWS\system32\cmd.exe"
Call Shell(strPrgm0, 1)

From the command window, I tested that the following command (I typed it in), which opens an Rscript and runs an R file from different directories, works:
C:\somepath\>"c:\DirectoryA\Rscript.exe" "c:\DirectoryB\TestRun.r"

My question is, how do I do the same (making the command line call) to execute the R run from VBA?

Thanks a lot.