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

2013-10-02 Thread Jeff Newmiller
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:Basics: ##.#. #

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

2013-10-02 Thread Johnson, Alex
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 Macro mode

2010-10-27 Thread Erich Neuwirth
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

[R] R-Excel Macro mode

2010-10-27 Thread Puijman, R.
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 Problem

2010-03-13 Thread RICHARD M. HEIBERGER
On Sat, Mar 13, 2010 at 11:51 PM, Megh 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 anything else

Re: [R] R-Excel Macro Problem

2010-03-13 Thread Megh
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 t

Re: [R] R Excel

2009-08-05 Thread spencerg
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 se

[R] R Excel

2009-07-28 Thread Hassan hany
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

2008-05-25 Thread nmarti
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. than

Re: [R] R-Excel Macro Problem

2008-05-25 Thread Yasir Kaheil
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:

Re: [R] R-Excel Macro Problem

2008-05-25 Thread nmarti
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

2008-05-25 Thread Yasir Kaheil
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': Application

[R] R-Excel Macro Problem

2008-05-24 Thread nmarti
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': Application-defined or object-defined error." Has anyone else encountered this same error message?