search for: putarray

...y insight into how I can avoid the dialog box would be appreciated. The macro is below. It's your basic, send-to-R, run R, retrieve-from-R macro. Call Rinterface.StartRServer Call Rinterface.RRun("rm(list = ls())") Call Rinterface.RRun("dev.off()") Call Rinterface.PutArray("mat1", Range("DATA_INPUT_OUTPUT!B7:I506")) Call Rinterface.PutArray("mat2", Range("DATA_INPUT_OUTPUT!J7:Q506")) Call Rinterface.PutArray("cpd", Range("DATA_INPUT_OUTPUT!A7:A506")) Call Rinterface.PutArray("name_of_assay_o...

...d out how to pass directly VBA array into R Below an example - sorry it is VBA - including a very simple call to R >> The below code function perfectly, my question is: How could I pass directly DblArray into R variable "test" >> So it would be something like: Call RInterface.PutArray("test", DblArray) >> But as could be expected I have an error because the RInterface.PutArray() is expecting an Excel range as second argument Any hint very appreciated! Thanks & regards, Julien Cuisinier Sub Demo1() Dim i As Long Dim j...

...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 read with RInterface.RunRCodeFromRange Range(...). Before this, I put Excel data to the required R variables with the RInterface.PutArray "...",Range(...). After the code is run, I want to get the variables from the code, which I want to do with GetArray. The model seems to work fine for small numbers of x, but with more than 5000 simulations, I get a VBA Run-time error '6', Overflow. The code works in R itself so...