Thx Michael, After some testing (with more luck then craftmanship) it appears that following code works: Call Shell(rPath & "\Rscript.exe " & """C:\Work\Latest 1\_Test.R""", vbHide) I'll also try your solution. SY, Bert
-----Original Message----- From: R. Michael Weylandt [mailto:michael.weyla...@gmail.com] Sent: 31 May 2012 23:51 To: Bert Jacobs Cc: r-help@r-project.org Subject: Re: [R] RScript.exe and map directory issue Not on Windows so I can't test, but I imagine you need to escape the space: try this: Call Shell(rPath & "\Rscript.exe C:\Work\Latest\ 1\_Test.R", vbHide) Michael On Thu, May 31, 2012 at 4:40 PM, Bert Jacobs <bert.jac...@figurestofacts.be> wrote: > Hi, > I'm trying to run on Windows 7 a scriptfile with Rscript.exe from within > Excel 2010 with the following code: > Call Shell(rPath & "\Rscript.exe C:\Work\Latest\_Test.R", vbHide) > > The good news is: the above code works perfectly, but ... > > If I add white spaces to my map directory, like: > Call Shell(rPath & "\Rscript.exe C:\Work\Latest 1\_Test.R", vbHide) > > In the above case or the RScript.exe doesn't run the file anymore. > Could someone explain to me how this comes and how I can deal with it? > > Kind regards, > Bert > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
