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? Kind regards, Bert
Not on Windows so I can't test, but I imagine you need to escape the space: try this: Call Shell(rPath & "\Rscript.exe C:\Work\Latest\ 1\_Test.R", vbHide) Michael On Thu, May 31, 2012 at 4:40 PM, Bert Jacobs <bert.jacobs at figurestofacts.be> 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? > > Kind regards, > Bert > > ______________________________________________ > 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.
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
Em 31/5/2012 17:40, Bert Jacobs escreveu:> 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? >Bert, I'm not a Windows guru, and do not have Windows 7 available to ascertain it, but in earlier versions of Windows, the subterfuge used to be to employ the "8.3" short name of the file (in fact the whole path) to circumvent the issue of spaces in {file,directory}names. To get the shortened name that Windows ascribe to a long, and potentially with spaces, in a filename you issue the command dir /x and you'd see a translation of longname to 8.3 filename. HTH -- Cesar Rabak