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 seems that Excel is opening the R console without any problems. > > The problem I am seeing is that Rinterface.RRun instruction is > interpreting the "\T" part of the path as an R command. It does not > recognize the "X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home > models\" as a one single string, or path. > > > Any ideas how can I fix the problem? > > Thanks ,' > > Jorge > > > VB code > Sub tester() > > Rinterface.StartRServer > > Rinterface.RRun > ("source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home > models\toto.R')") > > Rinterface.StopRServer > > End Sub > > > > "R cript code toto.R" > path = getwd() > setwd(path) > a = 5 > b=5 > x = matrix(rnorm(a*b),a,b) > a = 5 > b=5 > > y = matrix(rnorm(a*b),a,b) > z = x %*% y > savefile = paste(path,"/","testresults.csv",sep="") > write.csv(z, file = savefile) > > Rconsole message > > Type 'demo()' for some demos, 'help()' for on-line help, or > 'help.start()' for an HTML browser interface to help. > Type 'q()' to quit R. > > Loading required package: rcom > Loading required package: rscproxy > Error: '\T' is an unrecognized escape in character string starting > "source('X:\T"
R is just telling you that it doesn't recognize \T as a valid escape sequence in a character string. See R for Windows FAQ 2.16 and 5.1. Use \\ instead of a single \ as path separator or use the forward slash /. Berend ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.