R help - Oct 2013 - R Excel - Microsoft Excel is waiting for OLE action

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}}

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.