RE: [Rcom-l] Read Excel data

2008-01-23 Thread Uma Sitaraman
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

Re: [Rcom-l] Read Excel data

2008-01-23 Thread Richard M. Heiberger
> 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

Re: [Rcom-l] Read Excel data

2008-01-23 Thread Erich Neuwirth
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

Re: [Rcom-l] Read Excel data

2008-01-23 Thread Erich Neuwirth
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