[R] Rexcel path problem

2011-04-01 Thread Jorge Nieves
Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It seems that Excel is opening the R console without any

Re: [R] Rexcel path problem

2011-04-01 Thread Richard M. Heiberger
Jorge, This looks like an R on Windows problem, it is unrelated to VBA. You have the statement (source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R')) which is invalid R. You need to use either forward slashes or double-back-slashes in R commands. See the R for Windows

Re: [R] Rexcel path problem

2011-04-01 Thread Berend Hasselman
On 01-04-2011, at 16:12, Jorge Nieves wrote: Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It

Re: [R] Rexcel path problem

2011-04-01 Thread Jeff Newmiller
Use / instead of \ in the path. --- Jeff Newmiller The . . Go Live... DCN:jdnew...@dcn.davis.ca.us Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with

Re: [R] Rexcel path problem

2011-04-01 Thread Felipe Carrillo
/rbdd_jsmp.aspx - Original Message From: Jorge Nieves jorge.nie...@moorecap.com To: r-h...@stat.math.ethz.ch Sent: Fri, April 1, 2011 7:12:39 AM Subject: [R] Rexcel path problem Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow