Hi,
I tried to choose the foreground option in Set R server and configure R
but then it gives me the error "R Server not available". When I try to
Configure, I am not able to check the foreground option of the Typed
Server. It is also a Read-Only file.
Also, I don't understand the below paragrap
> It gives me an error "Run-time error 13- Type mismatch" and when I try
> to debug, it stops at line below in the RInterface Module.
>
this looks similar to what I am seeing on Burt's machine.
___
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
I checked with your code with some modifications,
beause I do not have your directories.
I got the same error because
The the program did not execute sample.R because it could not find it.
To debug:
Use rcom (not (D)COM and make the window visible.
Single step through your VBA code using F8 and
Shi
Run the following code to test it your connection between R and RExcel
is OK.
Sub DFTest()
RInterface.StartRServer
RInterface.RRun "x<-1:10"
RInterface.RRun "y<-10:1"
RInterface.GetDataframe "data.frame(x,y)", Range("A1")
RInterface.StopRServer
End Sub
It this works, more info