Re: [R] Physically open Excel file from R

Try shell('\"file.xls\"') where 'file.xls' is the excel filename. The escaped quotes (\") are not strictly necessary if the filename contains no spaces, but they are essential if it does. >>> Sergey Goriatchev 08/02/2010 12:48:20 >>> Hello, everyone I wonder if it is possible to PHYSICALLY

Re: [R] Physically open Excel file from R

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 : > > > On 08.

Re: [R] Physically open Excel file from R

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 r

[R] Physically open Excel file from R

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 V