Re: [R] Rexcel path problem

2011-04-01 Thread Felipe Carrillo
Jorge: You can run save your scripts in the same folder where your wokbook is and run it like this: Sub Scatter() Call rinterface.StartRServer 'Put the dataframe into R Call rinterface.PutDataframe("scatter", DownRightFrom(Range("RData!A1")), WithRowNames:=False) Call rin

Re: [R] Rexcel path problem

2011-04-01 Thread Jeff Newmiller
Use "/" instead of "\" in the path. --- Jeff Newmiller The . . Go Live... DCN: Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Contro

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

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 F