similar to: call R script from Excel VBA/macro

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

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

Is there an "easy" or good way to run/launch an Excel VBA macro from within R? --------------------------------- Pinpoint customers who are looking for what you sell. [[alternative HTML version deleted]]

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 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 like 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 the

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

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

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

Running Debian Etch with msttcorefonts installed, and Wine 0.9.58 Office 97 (Excel, Word, Powerpoint only, not Outlook etc) installed fine using Winecfg 'out of the box', setting default environment to Windows 98. Office 97 includes VBA, which can be started from Word's or Excel's menu: 'Tools, Macros, Visual basic Editor'. (The VBA editor is normally 3 panes, two

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

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

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

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

Hi, I would like to say that I've just solved the problem with my macro. It worked, I didn't need of the M$ VB's environment. The problem was in the treatment of variables "date" into my macro. For example: date 03/09/2002. With Win98/Excel, the variable assumes value "03/09/2002". With Linux/Wine/Excel, the variable assumes "3/9/2002". Did you

Hi, Is it possible to get M$Excel working with Wine? I use Mandrake 9.1 with wine-20030115-4mdk and M$Excel97 SR1 I always get an error about MSCREATE.DIR when I launch Excel. Console messages are: [steph@DeepGlue steph]$ wine /mnt/windows/Program\ Files/Microsoft\ Office/Office/excel.exe fixme:ole:CoRegisterMessageFilter stub Created not existing system directory 'C:\My Documents'

Dear all, I am trying to use R within Excel 97. Seems the VBA with Excel 97 does not recognize function "InStrRev" (it gives error message when I try to launch RExcel Help, just the same as that it doesn't recognize function "Replace"). A solution for frunction Replace has been provided (Ritter, Christian ,