RScript.exe and map directory issue

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
project.org] On Behalf Of Duncan Murdoch
Sent: Thursday, May 31, 2012 3:27 PM
To: Bert Jacobs
Cc: r-help at r-project.org
Subject: Re: [R] RScript.exe and map directory issue

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