On 08.02.2010 13:48, Sergey Goriatchev wrote:
Hello, everyone
I wonder if it is possible to PHYSICALLY open an Excel file from R.
The reason I ask is, I produce regularly an Excel file in R, and then
I want to make it look good, so I have a VBA routine in another Excel
file that works on the regular Excel file.
This formatting file executes VBA code on open, so all I need to do is
physically open it (no reading/writing at all). I wonder if that can
be done from R, so that I do as little as possible manually.
If you are under Windows and Excel is installed properly,
shell.exec("filename")
should do the trick.
Uwe Ligges
Thanks in advance for help!
Regards,
Sergey
--
Simplicity is the last step of art./Bruce Lee
Kniven skärpes bara mot stenen.
______________________________________________
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.
______________________________________________
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.
