[Rcom-l] Sheftel, Ryan is out of the office.

2008-11-04 Thread ryan . sheftel
I will be out of the office starting 11/03/2008 and will not return until 11/07/2008. If you need me before then please call my cell at 347-237-1732. ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listi

Re: [Rcom-l] OLE time-out problem

2008-09-02 Thread ryan . sheftel
I have used this in the past and it works great to solve this problem: http://groups.google.com.au/group/microsoft.public.excel.programming/browse_frm/thread/72df0d453fa8eebb/2d0abc64e322ac8d#2d0abc64e322ac8d?hl=en&lr=&rnum=1&prev=/groups%3Fq%3DMicrosoft%2BExcel%2Bis%2Bwaiting%2Bfor%2Banother%2Bap

Re: [Rcom-l] Option to start RExcel in foreground and background

2008-07-23 Thread ryan . sheftel
Is there a feature request list I could add this too? Erich Neuwirth <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/23/08 10:55 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] Option to start

[Rcom-l] Option to start RExcel in foreground and background

2008-07-21 Thread ryan . sheftel
Is it possible in my VBA code to start the RExcel session in either foreground or background mode based on a parameter, and that ignores the setting of the user. An example pseudo-code would be: RInterface.StartRServer("foreground") or RInterface.StartRServer("background") I once saw how do

[Rcom-l] Background RExcel

2008-07-13 Thread ryan . sheftel
When using RExcel, there is an option to set the instance of R used as "Background". When in this mode, is there any way to cause a GUI to appear for that instance of R. I would like to do this so I can view the variables and do other error checking while developing my spreadsheet. Thanks._

Re: [Rcom-l] Put Array from VBA

2007-11-29 Thread ryan . sheftel
Try making arrProject of type variant. - Original Message - From: "Yaning Zhang" [EMAIL PROTECTED] Sent: 11/29/2007 12:15 PM GMT To: "R (D)COM and RExcel server related issues" Subject: RE: [Rcom-l] Put Array from VBA Thanks for your reply. I tried, but it does not work, still sayin

Re: [Rcom-l] Put Array from VBA

2007-11-29 Thread ryan . sheftel
Try putting rvariable is quotes: Call Rinterface.PutArrayFromVBA("rvariable", arrProject) - Original Message - From: "Yaning Zhang" [EMAIL PROTECTED] Sent: 11/29/2007 11:28 AM GMT To: "R (D)COM and RExcel server related issues" Subject: [Rcom-l] Put Array from VBA Hello everyone,

Re: [Rcom-l] GetArrayToVBA

2007-11-20 Thread Ryan Sheftel
-l] GetArrayToVBA 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 row

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

[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