[R] 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,

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

There is a mailing list devoted to supporting RExcel that you should be posting on at http://rcom.univie.ac.at/. --- Jeff NewmillerThe . . Go Live... DCN:jdnew...@dcn.davis.ca.us

[R] R-Excel Macro mode

I'm using R-Excel's macro mode to make an R based Excel tool for inventory management. It's quite a lot of R-code which I made in R at first and now I am trying to transform it into excel. The R code is a simulation of a random path x times, put into matrices and then doing some transformations

Re: [R] R-Excel Macro mode

RExcel has its own mailing list, rcom-l. Please subscribe on rcom.unvie.ac.at and post your question on that list. On 10/27/2010 1:29 PM, Puijman, R. wrote: I'm using R-Excel's macro mode to make an R based Excel tool for inventory management. It's quite a lot of R-code which I made in R at

Re: [R] R-Excel Macro Problem

Hi, I was trying to run your code in my VBA editor, however could not succeed. The execution stumbled in the line Call Rinterface.StartRServer itself. I have RCOM package installed into my R environment. Do I need to install anything else to run that? Would guys here guide me? Thanks -- View

Re: [R] R-Excel Macro Problem

On Sat, Mar 13, 2010 at 11:51 PM, Megh megh700...@yahoo.com wrote: Hi, I was trying to run your code in my VBA editor, however could not succeed. The execution stumbled in the line Call Rinterface.StartRServer itself. I have RCOM package installed into my R environment. Do I need to install

Re: [R] R Excel

Have you looked at Heiberger and Neuwirth (2009) R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics (Springer)? Both Amazon and the Springer web site say it's not yet available. However, the Springer booth at the Joint Statistical Meetings was

[R] R Excel

Hi, whenever am trying to start R from excel, or by clicking the[ RExcel2007 with RCommander] icon., i got the following messages boxes : SCTools not available then: there seems to be no R process connected to excel though both r and excel starts after I click the Icon!! Please help Hassan

Re: [R] R-Excel Macro Problem

hi Nate, could you please email me your excel workbook. thanks y nmarti wrote: I'm trying to write R functions into VBA code. I've done this many other times in other documents and everything has run great. But today I keep recieving an error message Run-time error '1004':

Re: [R] R-Excel Macro Problem

Yasir, I couldn't find your email address, I'm new to the forum. Here's the code, Sub Run_ModelT() Call Rinterface.StartRServer Call Rinterface.PutDataframe(DataSet, Range(Peram!A1:E2000)) Call Rinterface.RRun(attach(DataSett)) Call Rinterface.RRun(model - lm(Ch_Close_1 ~

Re: [R] R-Excel Macro Problem

glad to hear things worked out. y nmarti wrote: Ok, so I'm embarrassed to admit I made a really dumb mistake. My VBA page was declared as Sheet1 code when it should have been Module1 code. I knew it was something stupid. Sorry for the inconvenience. Yasir Kaheil wrote: hi Nate,

Re: [R] R-Excel Macro Problem

Ok, so I'm embarrassed to admit I made a really dumb mistake. My VBA page was declared as Sheet1 code when it should have been Module1 code. I knew it was something stupid. Sorry for the inconvenience. Yasir Kaheil wrote: hi Nate, could you please email me your excel workbook. thanks y