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