[R] R Excel - Microsoft Excel is waiting for OLE action

[Jeff Newmiller]

There is a mailing list devoted to supporting RExcel that you should be posting on at http://rcom.univie.ac.at/.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

"Johnson, Alex" <Alex.Johnson at theaa.com> wrote:
>Hi,
>
> 
>
>I am hoping you may be able to help please?
>
>I am trying to use R Excel to run an R script using
>"RInterface.RunRFile"
>
>I have tested this command on basic scripts and they work fine. However
>when I try to run quite a long script which runs a number of forecasts
>using the forecast package, linear regressions and then tries to print
>and excel workbook I get the error
>
>Microsoft Excel is waiting for OLE action. It also opens a box that
>says
>R graphics. Both of which I can't get rid of and have to terminate
>excel.
>
> 
>
>The script works fine in R, although it takes about 8-10 minutes to run
>as it is on a lot of data and runs a number of things. But it does work
>fine.
>
>I wonder if it is the fact that the script takes so long to run that
>excel gets lost waiting for R to do its thing....
>
> 
>
>I was hoping if someone may be able to offer help please? If someone
>has
>had a similar problem which they were able to solve?
>
> 
>
>Or alternatively any idea of how to run an R script without the use of
>R
>Excel please? - through the command line?...
>
> 
>
>Thank you for your help
>
>
>Alex
>
> 
>
> 
>
>Alex Johnson
>
>Operational Research Analyst
>
>The AA
>
> 
>
>Automobile Association Developments Limited. Registered office: Fanum
>House, Basing View, Basingstoke, RG21 4EA. Registered in England and
>Wales Number: 01878835 
>
> 
>
>"To our Members we're the 4th Emergency Service"
>This electronic message contains information from The
>Au...{{dropped:17}}
>
>______________________________________________
>R-help at 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.