Re: [R] RScript.exe and map directory issue

2012-06-01 Thread 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

[R] RScript.exe and map directory issue

2012-05-31 Thread Bert Jacobs
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

Re: [R] RScript.exe and map directory issue

2012-05-31 Thread R. Michael Weylandt
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.jac...@figurestofacts.be wrote: Hi, I'm trying to run on Windows 7 a scriptfile

Re: [R] RScript.exe and map directory issue

2012-05-31 Thread Bert Jacobs
...@gmail.com] Sent: 31 May 2012 23:51 To: Bert Jacobs Cc: r-help@r-project.org Subject: Re: [R] RScript.exe and map directory issue 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

Re: [R] RScript.exe and map directory issue

2012-05-31 Thread Nordlund, Dan (DSHS/RDA)
-Original Message- From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- project.org] On Behalf Of R. Michael Weylandt Sent: Thursday, May 31, 2012 2:51 PM To: Bert Jacobs Cc: r-help@r-project.org Subject: Re: [R] RScript.exe and map directory issue Not on Windows so I

Re: [R] RScript.exe and map directory issue

2012-05-31 Thread Duncan Murdoch
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

Re: [R] RScript.exe and map directory issue

2012-05-31 Thread csrabak
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

Re: [R] RScript.exe and map directory issue

2012-05-31 Thread Nordlund, Dan (DSHS/RDA)
-Original Message- From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- project.org] On Behalf Of Duncan Murdoch Sent: Thursday, May 31, 2012 3:27 PM To: Bert Jacobs Cc: r-help@r-project.org Subject: Re: [R] RScript.exe and map directory issue On 12-05-31 4:40 PM, Bert