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
______________________________________________
R-help@stat.math.ethz.ch 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.
