similar to: running VBA code/macros within Linux

Hi, I am very new to R so please excuse me if I am asking very obvious questions. I am trying to call a blackbox api function implemented in as a COM object from R. The function definition says that 1. if calling from VBA, the first parameter should be set to "Nothing" 2. if calling from matlab, the first parameter should be set to [] What should be the equivalent for above in R?.

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

Hello everybody, at work I want to start R within an VBA program. First I calculate something in Excel 2003. After that I want to start within my VBA makro R wich should start an R file, say i.g, superplot.R which plots me the data well. So is it possible? Maybe something like that: sub test() 'calculate something start R superplot.R end test() Thank you so much. Kindly

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/

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

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 everyone, I want to convert an R function into VBA for calculating the eigenvectors and eigenvalues of a matrix using the "Power Method". The function is: PowerMethod <- function(x, tolerance) {     my.mat <- var(x[,-1], na.method="available")     matSize <- dim(my.mat)[1]     eigenVec <- matrix(NA, nrow=matSize, ncol=matSize)     eigenVal <- rep(NA,

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

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

I am running May 2001 Wine with Excel 7. When I open an xls file I get the error message that it can't find vbaen32.olb. The file is in /c/windows/system and this directory is in my path and system path. Anyone have any ideas?

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

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

Folks I have a macro that fails in Word, are there any work-arounds, alternate dlls etc that can be suggested to get it going? Is there any forum dedicated to getting these going? I've installed MSOffice like so: cd "/media/Office 2003 Pro/OFFICE";\ # Set your preferences WINEPREFIX=~/.MSOffice winecfg;\ # Click through the dialogues WINEPREFIX=~/.MSOffice winetricks wsh56 vb3run

You will create new databases and reports in R and VBA. You will also update and /or improve existing reports in R and VBA. Required: * Good knowledge of R is essential, mainly in the field of database mgt. Knowledge of statistics is not necessarily required. * Knowledge of VBA * You are a dynamic teamplayer who works efficiently and in a structured way Offer: Competitive reward Contract type to

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

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

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

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 ,

Many thanks to all who helped with my question last week about how to take the output of lm() and turn it into code that can be run on systems without R (using SQL, C, etc). This is a summary of the answers, caveats, and a solution including a little Perl script I wrote to do this. Brian Ripley pointed out an important caveat to this whole process - the model.matrix could contain R functions that