Dear Uwe,
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?
Best,
Sergey
2010/2/8 Uwe Ligges <lig...@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,
>
> 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.
>
--
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.
______________________________________________
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.
