[R] Physically open Excel file from R
sergeyg at gmail.com
Mon Feb 8 14:10:19 CET 2010
Worked as a charm! :-)
Thank you kindly.
Now, after I've run the VBA with shell.exec(), and closed the formater
and the formatted file, I still have Excel shell (=Excel with no files
open) open. Is it possible to close it from R as well?
2010/2/8 Uwe Ligges <ligges at statistik.tu-dortmund.de>:
> 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,
> should do the trick.
> Uwe Ligges
>> Thanks in advance for help!
>> Simplicity is the last step of art./Bruce Lee
>> Kniven skärpes bara mot stenen.
>> R-help at r-project.org mailing list
>> PLEASE do read the posting guide
>> and provide commented, minimal, self-contained, reproducible code.
Simplicity is the last step of art./Bruce Lee
The more you know, the more you know you don't know. /Myself
I'm not young enough to know everything. /Oscar Wilde
Experience is one thing you can't get for nothing. /Oscar Wilde
When you are finished changing, you're finished. /Benjamin Franklin
Luck is where preparation meets opportunity. /George Patten
Kniven skärpes bara mot stenen.
More information about the R-help