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
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
Jorge Nieves <jorge.nie...@moorecap.com> 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 messa
ge 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" > > Jorge Nieves
[[alternative HTML version
deleted]]_____________________________________________
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.
[[alternative HTML version deleted]]
______________________________________________
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.
