[R] RScript.exe and map directory issue

[Duncan Murdoch]

On 12-05-31 4:40 PM, Bert Jacobs 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?

Probably you'll need to put the file path in quotes.  I suspect either 
single or double quotes will work.

I don't know how to put quotes in a quoted string in Excel, but I 
imagine there's a way.

Duncan Murdoch