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