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: ##.#. #

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

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

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