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