similar to: can I run/launch an excel VBA macro from wihin R?

Hi, I was trying to run your code in my VBA editor, however could not succeed. The execution stumbled in the line "Call Rinterface.StartRServer" itself. I have RCOM package installed into my R environment. Do I need to install anything else to run that? Would guys here guide me? Thanks -- View this message in context: http://n4.nabble.com/R-Excel-Macro-Problem-tp858831p1592196.html

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

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

Buenos días: ¿Hay alguna forma de conectar VBA de Excel con R, de forma que desde Excel se puedan cursar instrucciones de R?, ¿ y V.Basic con R? Gracias anticipadas. Saludos [[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

Hi List, Is there any way to pass on directly VBA variable content into a R variable? on windows XP & using R 2.12.0 I have installed RExcel addin (with associated D(COM)) >> It function fine when trying to pass Excel Range to R but I failed (sorry if it is only my own limitation, search till now unsuccessful) to find out how to pass directly VBA array into R Below an example -

Muchas gracias, Sergio. Saludos cordiales. Eduardo Freyre -----Mensaje original----- De: miguel.angel.rodriguez.muinos en sergas.es [mailto:miguel.angel.rodriguez.muinos en sergas.es] Enviado el: viernes, 12 de julio de 2013 12:39 Para: efreyre en movistar.es; r-help-es en r-project.org Asunto: RE: [R-es] Conexion excel vba con R y VBasic con R Hola Eduardo. Lo que buscas lo puedes

Even using the VBA back of Excel to create interfaces with R would make a lot of sense. Suppose I could have access to VBA macros that import and export data into R , it would be great. The R GUI series like Rattle come even closer to Excel...so a VBA _R_ExCel package might be useful to ordinary folks . Besides Excel costs money, so adding R functions to Open Office would help both of them ( if

dear listers, right now, we are trying to use r to implement sas dde function, e.g. interact with excel. however, we can't find a way to call vba from r？ any insight is appreciated. [[alternative HTML version deleted]]

Hello All I've just started to use RExcel instead of CMD Batches. But I don't get the console output to an data.frame and push to Excel. With the CMD batch you got the console out relatively easy with C:\LocalData\R\bin\R CMD BATCH --slave %rscript% %logfile% to a file. But how can I get it to Excel with RExcel an VBA? Thanks, Dario [[alternative HTML version deleted]]

Dear all, I?m doing some simulation studies in order to compare the estimates (and estimated standard deviations) from the ARMA(2,1) Model with an estimator that I?ve constructed. For carrying out the simulations I created a VBA project within Excel. Now, I?m using the RExcel tool for running the R commands in the VBA project. I run 2500 simulation using the ?arima? function from R and it worked!

Does anyone know a way that an function written in R can be called within a cell of an Excel spreadsheet. I would like to use the R function much as I use the native Excel functions, e.g. instead of using the excel function sum, =sum(A2,A6), I would like to use the function mysum written in R, e.g. =mysum(A2,A6). Thanks, John John Sorkin M.D., Ph.D. Chief, Biostatistics and Informatics

Hi all, This is a little off-topic, but it is on the general topic of getting data in R. I'm looking for a excel macro / vba script that will export all spreadsheets in a directory (with one file per tab) into csv. Does anyone have anything like this? Thanks, Hadley -- http://had.co.nz/

Hola Eduardo. Lo que buscas lo puedes encontrar aquí.... http://www.statconn.com/products.html#RExcel Un saludo, _____________________________ Miguel Ángel Rodríguez Muíños Dirección Xeral de Innovación e Xestión da Saúde Pública Consellería de Sanidade Xunta de Galicia http://dxsp.sergas.es -----Mensaje original----- De: r-help-es-bounces en r-project.org [mailto:r-help-es-bounces en

I'm trying to write R functions into VBA code. I've done this many other times in other documents and everything has run great. But today I keep recieving an error message "Run-time error '1004': Application-defined or object-defined error." Has anyone else encountered this same error message? I do not recieve this error in the document when running regular VBA code.

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"

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 often work with R by writing long(ish) Excel-VBA macros interspersed with calls to R via RExcel. A typical example of this would be: Sub VBAMacro() 'fetch some data from an excel sheet 'do some basic stuff on said data 'transfer data from vba to R 'run some R statements 'get data back to vba 'show results on the excel sheet 'clean R by deleting all vars

Hi All, Server OS - SuSE Pro 9.0 Samba server version - samba3-3.0.9-1 (SuSE rpm) Client - Windows XP Pro SP 2 Office XP SP 2 I have everything working well such as machines joining domain, users logging in, roaming profiles etc. But when a user of the Samba domain tries to open a Excel VBA document, the following error occurs. "Error accessing the system registry" Please note that

Hi, . I know you can run Windows applications using WINE (winehq.com), but has anyone tried, say, running Word or Excel VBA code/macros based on Windows run time libraries? . the thing is that in their faq (http://www.winehq.com/site/docs/wine-faq/index) they don't even mention this possibility and searching on; VBA Word, doesn't give you any hits, even though WINE does link to windows