[R] shell and shell.exec on Windows

Erich Neuwirth erich.neuwirth at univie.ac.at
Sat Aug 11 11:58:32 CEST 2007


I have an Excel workbook "MyWorkbook.xls" containing an Auto_Open macro
which I want to be run from R.

shell.exec("MyWorkbook.xls")
does that.

shell("start MyWorkbook.xls")
also runs it.

In both cases, the Excel window is visible on screen when Excel is started.
Is there a way of opening the sheet with a hidden Excel window?
start has some parameters (e.g. /MIN), which should allow this, but
shell("start /MIN MyWorkbook.xls")
also starts Excel visibly.



-- 
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459



More information about the R-help mailing list