can accomplish what you want by assining the range to a VBA array,
creating a second VBA array with the hidden columns removed, and
use PutArrayFromVBA to transfer the modified array to R.
Rene Dreos (JIC) wrote:
> Hi all,
>
>
>
> I was wondering if it is possible to change the
Hi all,
I was wondering if it is possible to change the PutArray macro in order to
impede the data from hidden row/column to be transferred. I can not use the
PutDataFrame macro because the selection has not the column name.
Any suggestion will be kindly appreciated!
Thanks'
René
__
do
not work. Then changes are good that tings work again.
Rene Dreos (JIC) wrote:
> Hi, I run the functions and now it is clear that the differences between the
> two computers are on the OS language. The office computer that I used to
> develop the script is in English, rather then
Hi, I run the functions and now it is clear that the differences between the
two computers are on the OS language. The office computer that I used to
develop the script is in English, rather then the home computer is in Italian...
Here is the output of the office computer:
> RExcel.registry("11.
Where do I have to run the function? I am sorry, I am a new VBA and Rexcel
user...
Regards
René
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard M.
Heiberger
Sent: 22 October 2007 15:44
To: 'R (D)COM and RExcel server related issues
Hi all,
I encounter a weird error with RExcel and VBA:
I developed a simple macro on my computer and all seems to work fine, it
compiles and returns the result in the correct manner. But when I copied the
excel file with the macro to another computer (where I previously installed R
and RExcel)
Tools->References in the VBA IDE.
This is stated on the worksheet in the Writing Macros demo
(RDemoMacro.xls)
Rene Dreos (JIC) wrote:
> Hi all,
>
> I am a new user of RExcel and I am getting in trouble with macro... I
> install the software, check it, try the demo and all seem to
BAlib" in Tools->References, in
your VBA Editor.
Or add it manually if you don't find it in the list. The standard path is :
c:\Program Files\R\(D)COM Server\xls\RExcel.xla
Hoping it will help you
Julien Vanwinsberghe
Rene Dreos (JIC) a écrit :
>
> Hi all,
>
> I am a new u
Hi all,
I am a new user of RExcel and I am getting in trouble with macro... I install
the software, check it, try the demo and all seem to work properly... But when
I try this simple macro code
Sub demo()
Call RInterface.StartRServer
Call RInterface.StopRServer
End Sub
An error messag