RE: [Rcom-l] Put Array from VBA-query about enviroment

2007-11-30 Thread Yaning Zhang
Yes, thank you very much. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Friday, November 30, 2007 10:25 AM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Put Array from VBA-query about enviroment Not that I

Re: [Rcom-l] Put Array from VBA-query about enviroment

2007-11-30 Thread Erich Neuwirth
er > RInterface.PutArrayFromVBA ("AsVariant", arrProject) > RInterface.StopRServer > End Sub > > I would appreciate any advice. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Erich > Neuwirth >

Re: [Rcom-l] Put Array from VBA-query about enviroment

2007-11-30 Thread Erich Neuwirth
"AsVariant", arrProject) > RInterface.StopRServer > End Sub > > I would appreciate any advice. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Erich > Neuwirth > Sent: Thursday, November 29, 2007 4:00 PM

RE: [Rcom-l] Put Array from VBA-query about enviroment

2007-11-30 Thread Yaning Zhang
vember 29, 2007 4:00 PM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Put Array from VBA-query about enviroment It would help if you gave the exact command producing this error message. The following code works: Sub PutArrayTest() Dim MyVar As Variant Dim MyArray(1 To

Re: [Rcom-l] Put Array from VBA-query about enviroment

2007-11-29 Thread Erich Neuwirth
gt; [mailto:[EMAIL PROTECTED] *On Behalf Of *Yaning Zhang > *Sent:* Thursday, November 29, 2007 1:27 PM > *To:* R (D)COM and RExcel server related issues > *Subject:* RE: [Rcom-l] Put Array from VBA > > > > Yes, its type is variant. I checked the arrProject and it is correct

[Rcom-l] Put Array from VBA-query about enviroment

2007-11-29 Thread Yaning Zhang
D] On Behalf Of Yaning Zhang Sent: Thursday, November 29, 2007 1:27 PM To: R (D)COM and RExcel server related issues Subject: RE: [Rcom-l] Put Array from VBA Yes, its type is variant. I checked the arrProject and it is correct. From: [EMAIL PROTECTED]

RE: [Rcom-l] Put Array from VBA

2007-11-29 Thread Yaning Zhang
] Put Array from VBA 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

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

RE: [Rcom-l] Put Array from VBA

2007-11-29 Thread Yaning Zhang
2:13 PM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Put Array from VBA Try putting rvariable is quotes: Call Rinterface.PutArrayFromVBA("rvariable", arrProject) - Original Message - From: "Yaning Zhang" [

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 Ar

[Rcom-l] Put Array from VBA

2007-11-29 Thread Yaning Zhang
Hello everyone, I would like to assign the contents of a VBA array to an R variable, and I am using the following function. "arrProject" is a VBA array. Call Rinterface.PutArrayFromVBA(rvariable, arrProject) The first question is Do I need to define the "rvariable" name in VBA using "Di

[Rcom-l] Put Array From VBA

2007-11-22 Thread Yaning Zhang
Hello, I would like to assign the contents of a VBA variable "recProject" to a R variable "myrecord". recProject is defined as a recordset and its contents are like following: Index Code Lag MA AB 3 4 .. I am using the following code Call Rinterface.PutArrayFrom