Message-ID: <4FC7F025.1070804@gmail.com>
Date: 2012-05-31T22:26:45Z
From: Duncan Murdoch
Subject: RScript.exe and map directory issue
In-Reply-To: <4fc7d6c8.d1a3d80a.233a.ffff80f3SMTPIN_ADDED@mx.google.com>
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