> -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of R. Michael Weylandt > Sent: Thursday, May 31, 2012 2:51 PM > 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
The backslash character does not escape anything in the shell in Windows. You need to make sure that filenames/paths with spaces are surrounded by double quotes. So try something like Call Shell(rPath & "\Rscript.exe ""C:\Work\Latest 1\_Test.R""", vbHide) Hope this is helpful, Dan Daniel J. Nordlund Washington State Department of Social and Health Services Planning, Performance, and Accountability Research and Data Analysis Division Olympia, WA 98504-5204 ______________________________________________ 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.
