[Rcom-l] GetArrayToVBA

2008-04-16 Thread Christian Prinoth
In past versions of RExcel, I used to have trouble because GetArrayToVBA would return scalars, vectors or arrays based upon the dimension of the R object. Now it looks like it always returns a 2-dimensional array. I like this behaviour much more, but I would like to ask if this is how the function

[Rcom-l] GetArrayToVBA

2008-04-15 Thread Christian Prinoth
In past versions of RExcel, I used to have trouble because GetArrayToVBA would return scalars, vectors or arrays based upon the dimension of the R object. Now it looks like it always returns a 2-dimensional array. I like this behaviour much more, but I would like to ask if this is how the function

Re: [Rcom-l] GetArrayToVBA

2007-11-20 Thread Ryan Sheftel
That works! Thank you so much for your help. Erich Neuwirth <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/20/07 11:52 AM Please respond to "R \(D\)COM and RExcel server related issues" To "R (D)COM and RExcel server related issues" cc Subject Re: [Rcom

Re: [Rcom-l] GetArrayToVBA

2007-11-20 Thread Erich Neuwirth
Try Dim metricSurface As Variant Without the parentheses. Ryan Sheftel wrote: > > I am trying to use the GetArrayToVBA for a large dataframe in R into > Excel VBA. > > In R the dataframe "metricSurface" is a large (12 cols, 32760 rows) data > frame. > > I use the following in VBA t

Re: [Rcom-l] GetArrayToVBA

2007-11-20 Thread Ryan Sheftel
Sent by: [EMAIL PROTECTED] 11/20/07 11:48 AM Please respond to "R \(D\)COM and RExcel server related issues" To "R (D)COM and RExcel server related issues" cc Subject Re: [Rcom-l] GetArrayToVBA What kind of data does metricSurface contain? What versions or R and RExce

Re: [Rcom-l] GetArrayToVBA

2007-11-20 Thread Erich Neuwirth
What kind of data does metricSurface contain? What versions or R and RExcel are you using? Ryan Sheftel wrote: > > I am trying to use the GetArrayToVBA for a large dataframe in R into > Excel VBA. > > In R the dataframe "metricSurface" is a large (12 cols, 32760 rows) data > frame. > > I use th

[Rcom-l] GetArrayToVBA

2007-11-20 Thread Ryan Sheftel
I am trying to use the GetArrayToVBA for a large dataframe in R into Excel VBA. In R the dataframe "metricSurface" is a large (12 cols, 32760 rows) data frame. I use the following in VBA to retrieve it: Dim metricSurface() As Variant metricSurface = rinterface.GetArrayToVBA("a