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"
<rcom-l@mailman.csd.univie.ac.at>
Subject: RE: [Rcom-l] Put Array from VBA
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
_______________________________________________
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