search for: stoprserver

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

...d.table(""c:/test/Testb1.txt"", header=TRUE)") Call RInterface.RRun("passTestb1<-pass(Testb1, Threshold=5, ExtremeThreshold=5)") Call RInterface.RRun("passTestb1") Call RInterface.getArray("passTestb1", Range("D2")) Call RInterface.StopRServer end sub but I get an error : "unsupported data when trying to execute "passTestb1" I also tried: Dim x As StatConnector Set x = New StatConnector MsgBox ("Initializing R...") x.Init ("R") x.EvaluateNoReturn ("F11b1<-read.table(""c:/te...

...ectExcel('c:/TRY.xls')" RInterface.RRun "q1 = sqlFetch(A, 'Sheet1')" RInterface.RRun "odbcClose (A)" Worksheets("out").Activate Call RInterface.GetArray("q1", Range("A1")) Call RInterface.StopRServer End Sub i have included four examples below. on the left hand side we have the data as it appears in Excel and on the right hand side we have the output from the code (outputted to the 'out' sheet in excel). in the first example the code works while in the other three exampl0es it doe...

...cesita de la instalación de RPROJECT y REXCEL. He mirado varias guías e instalado los programas pero obtengo varios errores. El principal es que tras instalar RProject, Rexcel y statcon y al intentar correr esta macro desde Visual Basic… Sub Start() RInterface.StartRServer RInterface.StopRServer ActiveWorkbook.Save End … obtengo el siguiente error “Error de compilación No puedo encontrar proyecto o biblioteca”. He revisado los addin de VSB y todo parece correcto. Revisando la web vi que desde RProject tenía que correr este código: install.packages("RExcelInstaller", &...

...ng the cell and choosing Run Code. I have tried to write the macro for this operation as the following: Sub FindIndex() ' To run the price index in R Application.DisplayAlerts = False Rinterface.StartRServer Rinterface.RunRFile "S:/Folder/FileName.R" 'RInterface.StopRServer Application.DisplayAlerts = True End Sub But it returns the error "Error when sourcing R file S:/Folder/FileName.R" I have also tried a simple RInterface.RRun("source(""S:/Folder/FileName.R"")") But it did not work. Can anyone help me in writing this m...

...s - 1) For i = 0 To Elements - 1 DblArray(i) = Rnd() Next i Start = Timer Call RInterface.StartRServer Call RInterface.PutArray("test", RngData) Call RInterface.RRun("z<-median(test)") Call RInterface.GetArray("z", RngData2) Call RInterface.StopRServer 'Range("B1") = RngData2 Length = Length + Timer - Start Debug.Print Length End Sub [[alternative HTML version deleted]]

I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like this: setwd("C:/R_test") rnorm(100) write(rnorm(100),"data.txt") q(save="no", runLast = F) Next I would like use an Excel VBA/macro Shell() function to call R and execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)* I wrote an Excel macro RunRcode like this: Sub

...e("ASYM_MAX_ANALYSIS!D64")) Call Rinterface.GetArray("pv_data$lin", Range("ASYM_MAX_ANALYSIS!I64")) Call Rinterface.GetArray("pv_data$FO", Range("ASYM_MAX_ANALYSIS!J64")) Call Rinterface.RRun("dev.off()") Call Rinterface.StopRServer Joe Boyer Statistical Sciences Renaissance Bldg 510, 3233-D Mail Stop RN0320 8-275-3661 cell: (610) 209-8531 [[alternative HTML version deleted]]

I wrote a R script say called computeCovarMatrix.R and i want to call and run this piece from Excel visual basic. does anyone know how to do that? thanks, KZ [[alternative HTML version deleted]]

Dear all I use ggplot2 extensively for my plotting routines and rexcel to have the best of two worlds. (RExcel v 1.75 and R (D)Com v. 2.5) I can run my ggplot functions, such as qplot(...), in scratchpad mode, but not in Macro nor Worksheet functions mode. I have tried the following in Macro mode: Call RInterface.RRun("library(ggplot2)") ... Call