Thank you very much for your help. I will try to find the book.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich
Neuwirth
Sent: Wednesday, December 19, 2007 4:52 PM
To: R (D)COM and RExcel server related issues
Subject: Re: [Rcom-l] Put R valur into Execl Range
mynum=Rinterface.GetArrayToVBA(mynum)
Rinterface.GetArray("variable", Range("Sheet1!A" & CStr(mynum))
And you shoud definitely read a good book about VBA programming.
I highly recommend
John Walkenbachs
Excel .... Power Programming
You have to get num into VBA with, say, RInterface.GetArrayToVBA
if you assignt his to a VBA variable numvba then you can do
Yaning Zhang wrote:
> Thank you for your reply. I am afraid I am not sure I totally
understand
> what you mean. For the string functions. Do you mean the following
> method?
>
> Dim mynum As String
> Thank you.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Erich
> Neuwirth
> Sent: Wednesday, December 19, 2007 4:37 PM
> To: R (D)COM and RExcel server related issues
> Subject: Re: [Rcom-l] Put R valur into Execl Range
>
> Use either string functions or the
> Cells property of the Range
> Yaning Zhang wrote:
>> Hello,
>>
>>
>>
>> I could use some help here. Say I have got an R expression "num",
> which
>> is a single number. What I want to achieve is like following,
> including
>> the "num" in the sheet range.
>>
>>
>>
>> Call Rinterface.GetArray("variable", Range("sheet1!A(num)"))
>>
>>
>>
>> But it dose not work. Any thought on it?
>>
>>
>>
>> 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
> _______________________________________________
> 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
_______________________________________________
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
