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" <ggrothendi...@gmail.com>
02-Feb-2009 18:53
To
joseph.g.bo...@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.bo...@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]]
______________________________________________
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.
