similar to: R & VBA

When I run a macro that uses RExcel, I get a dialog box that says "Microsoft Excel is waiting for another application to complete an OLE action." There is no error in the RExcel commands in the macro, of that I am sure. The box appears to be related to the inclusion of RunRFile commands. The macro will run through the second RunRFile command, but will not execute the

I'm using R-Excel's macro mode to make an R based Excel tool for inventory management. It's quite a lot of R-code which I made in R at first and now I am trying to transform it into excel. The R code is a simulation of a random path x times, put into matrices and then doing some transformations on it. I pasted the R code on a seperate sheet in my Excel file, which by means of VBA I

Issue: Usage of ETS R codes through RExcel macros in VBA Given below is my command code: Rinterface.runrcodefromrange Range(?Sheet1!B2:D8?) Following are the codes written in the given cell reference: #!rput zz 'Sheet1'!$B$2:$B$22 library(forecast) zz <- ts(zz,freq=365,start=c(2009,1)) etsz <- ets(zz,model='AAN') etszP <- forecast(etsz,h=34) write.table(etszP) How

Hi, I am using R version 2.14.0 on windows 7. Trying to use RCOM package and followed example provided at (http://cran.r-project.org/web/packages/rcom/rcom.pdf) . I am able to load the com object as seen in screenshot 2.png. however I am unable to invoke/get/set property to the object. Please guide me on the same, Regards; Kumar Anand

Hello, I am trying to embed R-code inside VB for Excel (probably a perverse endeavour anyway) and I am running into difficulties, especially when passing vectors back and forth between the two environments. (1) I am using the RExcel package. (2) An example of error that I often get and that I can't seem to be able to work myself around of is the following VB message: ------ Run-time

Dear list, I'm trying to use R2wd package. I've installed the package and try wdGet(). However a error message came up. I'm presently using R 2.15.0 > wdGet() Error in if (wdapp[["Documents"]][["Count"]] == 0) wdapp[["Documents"]]$Add() : argument is of length zero Does anyone knows what this means? Thanks a lot. Andreia Leite -- View this

Hello all, I’m new here and this is actually my very first post. My name is Giannis and I am an undergraduate student. I am programming in Microsoft’s Visual Studio 2010 (VB.NET mostly) and I want to create a program for the research group I am in. I merely want to evaluate actions and use simple statistical things such as ks test (Kolmogorov-Smirnov), and some plots. The reason I need to call R

Hi list, How to save a list content into a text file? Please consider example below, I have two numeric matrices that I bundle into a list & give each list element a name Example: > matrixA <- matrix(0,5,4) > matrixB <- matrix(1,7,13) > matrixList <- list(matrixA,matrixB) > names <- c("Matrix A","Matrix B") > names <-

David - information on calling R from within Mathematica can be found at the following link: http://www.mofeel.net/1164-comp-soft-sys-math-mathematica/13022.aspx HTH, Alan Kelly

Hola tengo q hacer un trabajo, donde me piden q todas las salidas q haga sean en Power Point (graficos, tablas, etc). Para eso habia empezado a leer algo del paquete R2PPT, pero la verdad es q hay cosas q no entiendo de este paquete. Queria saber si alguien estuvo trabajando con el y obtuvo buenos resultados o si han usado otro paquete para hacerlo. Por ultimo una pregunta: desde Sweave se

Hi to all, there are some binary .dmg packages to install easly rpy under mac os x? I'm tryin' to install Rpy under Mac Os X but I receive the following message: host46-209-dynamic:rpy usernone$ python setup.py install running install running build running build_py running build_ext building 'rpy2.rinterface.rinterface' extension gcc -arch ppc -arch i386 -isysroot

I'm struggling with interpreting XML files created by ADODB as data.frames and I'm looking for advice (see attached example file). Note: This file contains a result set which comes from a rectangular data array. I've been trying to play with parameters to the xmlToDataFrame function in the XML package but I dont get it to extract the data frame. This is what the result should look

Hola a todos, Mi nombre es Juanjo. Llevo un tiempo intentado hacer funcionar un programa que necesita 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

I am trying to do a surface profile plot. data is X                  Y(1)             Z(1) 1-jan-02       2002        number 2-jan-02       2002        number . . . 1-jan-03       2003 (Y2)     number Z(2) 2-jan-03       2003 (Y2)     number Z(2) . . . until dec 31 2007.   I used the plot3d funtions to build a scatter point plot. Call rinterface.rrun("library(rgl)") Call

Hi, I'm trying to combine a VBA macro and a R package. I've installed the R-(D)COM and the R-excel interface by Neuwirth. They seem to work both. However I would like to display the r-generated data in an Excel sheet as an array but I don't manage. Here is an example of my source: Sub doR() Call RInterface.StartRServer Call RInterface.RRun("library(mdnn)") Call

hello all i have a quick question. i have been using the RODBC library (trying to read Excel data into R but i am doing this by using Rexcel. this is probably not the correct forum - sorry for this). my code is shown below: Sub A() 'start the connection to R Call RInterface.StartRServer RInterface.RRun "library(RODBC)" RInterface.RRun "A =

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

Hi! I want to use R for network analysis and have tried to install the 'igraph' package. Unfortunately, the installation is aborted by an error: --snip-- gcc -std=gnu99 -I/usr/lib64/R/include -DNDEBUG -I/usr/local/include -DUSING_R -I. -Ics -Iglpk -Iglpk/amd -Iglpk/colamd -I/usr/local/include -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables

Hello all, I`m a computer science student from Frankfurt/main (germany). Our student team (10 students) are working on a R/Interface project (Java and R) and we have a problem with R and JRI. We are working on 10 computers with Windows XP SP2, R 2.8.0, jdk1.6.0_11 and the same classpath setttings but our application works only on two computers. We can't explain us this.

Dear R-help, Call RInterface.StartRServer ' Works fine Call RInterface.RRun("objects()") ' Works fine Call Rinterface.RRun( other R commands which do not generate errors, the demos etc ) ' Works fine But ... Call RInterface.RRun("doesnotexist") ' Sends Excel into endless loop it appears After about 90 seconds a dialog box appears "Microsoft