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@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.
