Thanks for your reply. I tried, but it does not work, still saying could not find the object "rvariable" if I call it the R console.
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 29, 2007 12: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" [EMAIL PROTECTED] Sent: 11/29/2007 11:28 AM GMT To: "R (D)COM and RExcel server related issues" <rcom-l@mailman.csd.univie.ac.at> Subject: [Rcom-l] Put Array from VBA 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 "Dim rvariable As String" or any other type of variable? It seems like if I do not define it, it will comes out the error message saying variable undefined. Then after naming it, I call "rvariable" in the R console, but it says object not found. Could anyone give me some advice? Many thanks. Yaning Zhang
_______________________________________________ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at
