[R] RScript.exe and map directory issue

[Bert Jacobs]

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.