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 2, 1 To 2)
Dim MyVarArray(1 To 2, 1 To 2)
MyArray(1, 1) = 11
MyArray(1, 2) = 12
MyArray(2, 1) = 13
MyArray(2,
Hello, I guess it is useful to point out the error message in R console
is like this "Error in eval(expr, envir, enclos) : object "rvariable"
not found.
I do not quite understand what this means.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Y
Yes, its type is variant. I checked the arrProject and it is correct.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, November 29, 2007 12:57 PM
To: R (D)COM and RExcel server related issues
Subject: Re: [Rcom-l]
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
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:
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,
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
