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.weylandt at gmail.com] Sent: 31 May 2012 23:51 To: Bert Jacobs Cc: r-help at 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.jacobs at 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 at 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.