[R] RScript.exe and map directory issue

[Erich Neuwirth]

To put double quotes in a string in VBA one has to use double double quotes

str = "a string with a ""quoted"" word"



On Jun 1, 2012, at 12:26 AM, Duncan Murdoch wrote:

> 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
> 
> ______________________________________________
> 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.