similar to: R Excel - Microsoft Excel is waiting for OLE action

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

Hi, I'm using R-2.8.1 for windows. I wrote a script calls the RODBC package to run sql queries against an oracle database. It runs fine when run from the rconsole and returns a data.frame with a summary for a set of experiments. I want to run this script using the rinterface.RunRFile command in an excel plugin, using the rexcel package. When I run the code from my excel plugin I

Dear All, I am experiencing a problem for which I need some help. I have created a small file containing a simple function File name = smalltest.r Content : smalltest=function(extvar) { itworks=paste('Ca marche',date()) setwd("c:/windows/temp") write.table(itworks,file="resultat.csv", append=FALSE) } This function works when operated from R environment To get

Hi, I am using RExcel and trying to pass a line of code into R. When I select the cell and choose "Run Code" from the RExcel menu then it seems to work fine. The problem I face is a need to write a macro to do this operation, as I need to set up a user interface in excel for other users who don't know how to use R. In R to run my entire code I simply write on line:

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

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

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"

S-PLUS ESSENTIALS 24-27th April 2006 Venue : Insightful UK Office, Network House, Basing View, Basingstoke, Hants RG21 4HG We are pleased to be taking registrations for the next scheduled S-PLUS Essentials course being held in Basingstoke 24-27th April 2006. If you are unfamiliar with S-PLUS or have been meaning to upgrade your S-PLUS skills, this is the course for you. This course will be

Analysis of Microarray Data Using S-PLUS, R and S+ArrayAnalyzer 23rd March 2006 Presenter: Adam Diaz Venue: Insightful UK, Network House, Basing View, Basingstoke, Hants RG21 4HG This is the last chance to register for this unique course being run by a member of Insightful's microarray development team from the US. Extract Microarray technology is complex, and experiments using

We (Eli Lilly & co) have a vacancy for an experienced industrial statistician who is familiar with mainstream statistical software, particularly Splus (or R) and/or SAS and/or JMP. The role is to provide expertise and training in Statistics in support of process-improvement in all areas of the business, particularly Statistical Process Control, Design of Experiments, and Quality

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

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

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

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

Dear All, I have attempted to install the R-Excel Interface with poor results. The version of R is 1.6.1, the version of R-Excel is 1.0, the version of COM is 0.99. All of these were downloaded Monday, 6 January 2003. R (version 1.6.1) is installed on the machine and appears to run correctly on its own. The computer is a Compaq Pentium 4 machine with 128 meg of RAM running Windows 2000 and

Insightful are now taking bookings for the Financial Time Series Modelling course to be held at Carlton Terrace in London SW1 on 12th and 13th April 2005. We are also pleased to offer the 1 day Advanced Time Series Modelling course on April 19th at the same location. Extract for Financial Time Series Modelling : This two day course will provide participants with a working knowledge of a range

Hi list, I would like my mail directory structure to be like this: /var/vmail/firstletterdomain/domain/username what would be the syntax in dovecot.conf? Thanks, chantal

Insightful are now taking bookings for the Advanced Time Series Modelling course to be held at Carlton Terrace in London SW1 on 20th September. Advanced workshop Extract for Financial Time Series Modelling : The Advanced Time Series Course focuses on the most up to date theory and its application around the following topics (note that not all topics will be covered during the workshop) 1.