Thank you, I appreciate your reply.

I have managed to get Shell("c:\TEMP\Rbatch.bat") to work.

What solved the problem was saving the Rbatch.bat file as type "All files"
as opposed to as a text file.

Why that worked, I have no idea.


Joe Boyer
Statistical Sciences 
Renaissance Bldg 510, 3233-D
Mail Stop RN0320
8-275-3661
cell: (610) 209-8531



"Gabor Grothendieck" <ggrothendieck@gmail.com> 
02-Feb-2009 18:53
 
To
joseph.g.boyer@gsk.com
cc
r-help@r-project.org
Subject
Re: [R] executing R batch files






Without the actual VBA commands you are using we
can't be sure but if you are using Shell then it requires an exe,
not a bat file.  Try
   cmd.exe /c RBatch.bat
so that it has an exe file to execute.

On Mon, Feb 2, 2009 at 6:42 PM,  <joseph.g.boyer@gsk.com> wrote:
> The following command, issued from the DOS command prompt (running 
Windows
> XP), produces the intended result of a .csv file created by program.R:
>
> ?c:\program files\R\R-2.8.0\bin\Rterm.exe? --save < "c:\TEMP\program.R"
>
> However, when I create a file called Rbatch.bat that contains exactly 
the
> line above, and try to execute it (by double clicking or via the Shell
> command
> in an Excel macro), nothing happens.
>
> Does anyone have an explanation, or any suggestions as to how to run an 
R
> program from within an Excel macro? (PS: I know about RExcel, can't 
quite
> get it to install
> correctly.)
>
> Much appreciated.
>
>
>
> Joe Boyer
> Statistical Sciences
> Renaissance Bldg 510, 3233-D
> Mail Stop RN0320
> 8-275-3661
> cell: (610) 209-8531
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>



	[[alternative HTML version deleted]]


